Title: help complex query
Last modified: July 23, 2021

---

# help complex query

 *  [jviure](https://wordpress.org/support/users/jviure/)
 * (@jviure)
 * [4 years, 10 months ago](https://wordpress.org/support/topic/help-complex-query/)
 * Hi! I don’t know if it’s complex but I don’t know how to attack it. Well, I ve
   woocommerce in my site. Every product has it’s own acf fields. I ve a repeater
   field. I want to do filter products if repeater field has something..
 * Example:
 * Product1. Has the repeater field filled… so I ve to add an extra where.
    Product2.
   Repeater field empty. Ignore extra where. …
 * In raw sql I would have a: WHERE… (case when _repeater\_field\_filled_ then acf_field_X
   = ‘value’ else 1=1 end) .. something like that
 * Some help? 😛

The topic ‘help complex query’ is closed to new replies.

 * ![](https://ps.w.org/advanced-custom-fields/assets/icon.svg?rev=3207824)
 * [Advanced Custom Fields (ACF®)](https://wordpress.org/plugins/advanced-custom-fields/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/advanced-custom-fields/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/advanced-custom-fields/)
 * [Active Topics](https://wordpress.org/support/plugin/advanced-custom-fields/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/advanced-custom-fields/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/advanced-custom-fields/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [jviure](https://wordpress.org/support/users/jviure/)
 * Last activity: [4 years, 10 months ago](https://wordpress.org/support/topic/help-complex-query/)
 * Status: not resolved