We are trying to create an automation that will add users to a list if one of the custom fields in Event Booking = "Yes". I know I can pull this information with a SQL statement
select f.field_value from #__eb_field_values f left join #__eb_registrants r on r.id = f.registrant_id where r.user_id = '[user_id]' and f.field_id = 63 order by f.id Desc limit 1
I have used that code to create a Community Builder custom query field that shows the result.
I have also tried to use the CB Query field in ACYM6, however it wont show up in the filter drop down.
We used the Universal Filter in ACYM5 to accomplish something like this in the past, however ACYM6 still is missing that function.
