PSFS IQ - Family Directory: How to query a list of families with children

For Census purposes you may need a list of all Families who have children.  To do this you can create a simple Query with sub-query to pull the information for you.

 

Results Columns

  • Families > Family DUID 
  • Families > Last Name
  • Families > First Name 
  • Families > Envelope Number
  • Add contact and or/mailing data if wanted. 

 

Query Conditions:

  • Families > Family DUID not in sub-query
  • Organization > Organization ID is equal to [POL].
  • Click the option to Edit sub-query.

 

Edit sub-query Screen

In the sub-query add a condition for "Members Age" and set it to "less than" and enter the age.

Once finished, hit "Ok".  The sub-query window will close and you may now run the query.

.

Run the query

  • To run the Query, make sure the "Unique Records Only" box is checked at the bottom.
  • Click Execute Query.
  • To export results click "Query Results" and select Export to CSV and it will put your results in an excel file for easy sorting, printing, and viewing. 

 

 

 

Related Articles

How to create sub-queries in IQ

 

Top

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request