How to make a list of all families outside a family workgroup
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 the Query Conditions.1
Query Conditions: 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, 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.