PSFS IQ - Query Builder: How to create sub-queries in IQ

A sub-query is a query within a query.  Think of it as a sub-set of conditions applied to a query.

 

Add a sub-query within the conditions area

The other option for sub-queries comes within the conditions area. 

 

Once you've added a condition on which to build the sub-query, click the link to change the value of your condition.  Select "in sub query" to build the sub-query from here:

 

Once the condition is changed, you'll see a link to edit the sub-query:

 

After you click on this link, a new window will open where you can add the group of conditions:

 

Once all conditions have been added, click OK to close the window and return to the query.  You won't see the conditions in the sub-query from the main IQ page but can click the "edit sub-query" link to view your group of conditions at any time.

 

Related Articles

How to find all results that do not match a condition

 

 

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request