How to make a list of all families outside a family workgroup
If you do not yet know how to create an IQ Query, first review the following article to learn: How to create, run, modify, and save a new query
Result Columns: First, from the IQ module, add the Result Columns (such as family contact info) needed, but include "Families: Family DUID" in the Result Columns AND in the Query Conditions.1
Query Conditions: The operator for the Family DUID is 'not in sub query.' Add your registration condition if you want registered families only.2 Click "[Edit in sub-query]" to the right of condition: "Families: Family DUID" and your sub-query will open.
- In the sub-query Conditions, add "Families: Workflow Group Membership: GroupName" then "is equal to4."
- Type the name of the Workgroup you need to exclude5. Click OK.
- Now click "Execute Query." This will be all the registered families NOT in that workgroup.
How to create sub-queries in IQ
Please sign in to leave a comment.