Important Notice: This article applies to the New ParishSOFT Platform. If your diocese hasn’t migrated yet, explore our knowledge base for relevant resources.
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.
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, notice the link to edit the sub-query:
After clicking on this link, a new window will open, add new conditions:
Once all conditions have been added, click OK.
To close the window and return to the query.
Conditions in the sub-query are not visible from the main IQ page but click the "edit sub-query" link to view the sub-query conditions at any time.
Updated