PSDio IQ - How to build a query to report all registered families per organization

How to build a query to report all registered families per organization

Below is an image of a query that will return all registered families based on organization information. This will give the count of all registered families that are at the selected organization with Organization ID, Organization Name and City of the Organization. 

As the example shows, you may rename the columns on the right-hand side in order for the results columns to read easier. To get the correct results, you will need to do a 'count' of the family DUID. If you do a 'Sum,' it will add together each family DUID; so do a 'Count' and not a 'Sum'. 

IQ_for_List_of_Orgs_with_registererd_families.jpg

 


Related Articles

How to write a query reporting family information for those registered to a specific organization and who want to receive mail

Top

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.