Hi @inforesist
Could you please tell me which custom field type was that? ACF has several hooks to modify the query of some custom field types. acf/fields/post_object/query for the post object field, acf/fields/relationship/query for the relationship field, and acf/fields/taxonomy/query for the taxonomy field.
I hope this helps.
