PSFS IQ - Family Directory: How to make a list of all families outside a family workgroup

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.

 


Related Articles

How to create sub-queries in IQ

 

Top

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.