Hi, New to ACF and have made a field group called customer_additional_info with a text field called customer_display_name. This works on the taxonomy Customer that I have created, and the fields are displayed and data entered is saved.
However, I have a shortcode that uses SQL to gather names and info about each Company and display it in a list. I am able to get all the standard info about the Company, but not the ADF fields.
$members_list = $wpdb->get_results(
“SELECT * FROM wp_term_taxonomy as tx, wp_terms as tr, wp_termmeta as tm
WHERE tx.taxonomy = ‘companies’ AND
tr.term_id = tx.term_id AND
tm.term_id = tx.term_id AND
tm.meta_key = ‘membership_type’ AND
(tm.meta_value != ‘Draft’ AND tm.meta_value != ‘Inactive’) AND
(tm.meta_value = ‘Adopter Company’ OR tm.meta_value = ‘FULL Member Company’ OR
tm.meta_value = ‘Tools Member’)
ORDER BY name ASC”);