PSDio - IQ - All Registered Families Per Organization

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

I have renamed the columns on the right-hand side in order for the results columns to read easier. In order for this query to work, you will need to do a 'count' of the family DUID. If you do a 'Sum' then it will literally add together each family DUID, so do a 'Count' and not a 'Sum'.

 

IQ_for_List_of_Orgs_with_registererd_families.jpg

 

Related Queries 

PSDio - IQ - Registered Families, Per Org ID, Send No Mail Equals No

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.