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

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: Add Family First and Last names with other necessary information (1). The fields added in the screenshot below are mailing name, envelope, and mailing address in mine. See IQ screen.

Query Conditions: Add Family DUID (2); add Organization ID if you're going to save the Query Globally.  Set "Families Family DUID" to "not in sub-query" and click the option to "Edit sub-query" (3). See IQ screen.

.

IQ Screen

 

.

Edit sub-query Screen

In the sub-query add a condition for "Members Age" and set it to "less than" and enter the number 17 or 18 (depending on when your Parish recognizes adulthood). (1-4)

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

2018-02-09_10-23-12.jpg

.

Run the query

  • To run the Query, make sure the "Unique Records Only" box is checked at the bottom (1).
  • Click "Execute Query" (2).
  • 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 (3). 

 

2018-02-09_10-40-58.jpg

 

 


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.