Title: More Complex Queries
Last modified: September 7, 2019

---

# More Complex Queries

 *  [dmunaretto](https://wordpress.org/support/users/dmunaretto/)
 * (@dmunaretto)
 * [6 years, 9 months ago](https://wordpress.org/support/topic/more-complex-queries/)
 * I have spent a fair amount of time on the forums here, and I know where most 
   of the answer come from… so to those that give of their free time, thank you.
   Do you think it would be possible for those that are using this to post working
   examples, rather than posting things that don’t work? I think it would be immensely
   useful…
 * I am working on a site, and while I think this plugin can provide the necessary
   mechanism for looping through the posts and filtering to the correct ones that
   match the criteria, I am having a hard time getting it to work – Basically, I
   have a series of conditions that must be true and if all are true display the
   related posts:
 * This seems to get the first right but not the rest –
    [if field=ABCD] [pass fields
   =YY,ZZ,AA,BB,CC,DD] [loop type=sometype field=xx compare=”>=” value={YY} field
   =ab compare=”>=” value={ZZ} field=cd compare=”like” value={AA} ] [field title-
   link] [/loop] [/pass]
 * This returns results where xx>=YY but stops after that comparison. SO ab>=ZZ 
   doesn’t process.
 * I could use some examples of what other people have done. I have tried nesting
   if’s within the loop and that hasn’t helped either….
 * [if field=ABCD]
 * [pass fields=YY,ZZ,AA,BB,CC,DD]
 * [loop type=sometype]
    [-if field=xx compare=”>=” value_2={YY}] [–if field=ab 
   compare=”>=” value_3={ZZ}] [—if field=cd compare=”like” value_4={AA}] (NOTE THAT
   IT SEEMED TO REQUIRE ONLY VALUE TO HAVE _# IN ORDER TO WORK??)
 * [field title-link]
    [/—if] [/–if] [/-if]
 * [/loop]
    [/pass] [/if]
 * Should I be approaching this differently? I have an entire series of conditions
   all of which must be true in order to return a result… What am I missing? I could
   use some advice 😉

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Thread Starter [dmunaretto](https://wordpress.org/support/users/dmunaretto/)
 * (@dmunaretto)
 * [6 years, 9 months ago](https://wordpress.org/support/topic/more-complex-queries/#post-11908285)
 * Here is a sample of passing a field from the current page to query a custom post
   type of agent and return details about the agent that I am using.
 * [pass field=real_user] NOTE: THIS IS THE FIELD FROM CURRENT POST
    Type: [loop
   type=real_people id={FIELD}] (THIS SAYS LOOK AT THE POST TYPE REAL PEOPLE FOR
   VALUE IN REAL USER FIELD THAT WAS PASSED) [content type=agent field=user_type](
   THIS SAYS SHOW CONTENT FROM AGENT FIELD USER_TYPE [/loop] [/pass]
 *  Thread Starter [dmunaretto](https://wordpress.org/support/users/dmunaretto/)
 * (@dmunaretto)
 * [6 years, 9 months ago](https://wordpress.org/support/topic/more-complex-queries/#post-11909954)
 * OK I’ve spent all day testing this, I can get up to field_4 compare_4 value_4
   to work. After that it doesn’t appear to work — is there a limit on the number
   of compares you can filter on?
 *  Thread Starter [dmunaretto](https://wordpress.org/support/users/dmunaretto/)
 * (@dmunaretto)
 * [6 years, 9 months ago](https://wordpress.org/support/topic/more-complex-queries/#post-11909968)
 * Here is my code:
 * [if field=acf_property_type value=”Farm”]
    [pass fields=barn_size,barn_stalls,
   barn_loft,barn_hay,city] [loop type=property field=acf_property_type value=”Barn”
   field_2=”x_max_barn_size” compare_2=”>=” value_2='{BARN_SIZE}’ field_3=”x_barn_stalls”
   compare_3=”>=” value_3='{BARN_STALLS}’ field_4=”x_barn_loft” compare_4=”>=” value_4
   ='{BARN_LOFT}’ _[note] Any fields after field\_4 don’t appear to work [/note]_
   field_5=”x_barn_hay” compare_5=”>=” value_5={BARN_HAY} field_6=”x_city” compare_6
   =”=” value_6={CITY}]

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘More Complex Queries’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/custom-content-shortcode_766976.svg)
 * [Custom Content Shortcode](https://wordpress.org/plugins/custom-content-shortcode/)
 * [Support Threads](https://wordpress.org/support/plugin/custom-content-shortcode/)
 * [Active Topics](https://wordpress.org/support/plugin/custom-content-shortcode/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/custom-content-shortcode/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/custom-content-shortcode/reviews/)

 * 3 replies
 * 1 participant
 * Last reply from: [dmunaretto](https://wordpress.org/support/users/dmunaretto/)
 * Last activity: [6 years, 9 months ago](https://wordpress.org/support/topic/more-complex-queries/#post-11909968)
 * Status: not resolved