PSDio - IQ - Registered Parishioners Giving to Certain Fund for a Certain Parish

The purpose of this query is to help you get family information for parishioners who are registered to a parish and who have given on behalf of that organization. The query columns simply have the families formal salutation and email address, you may wish to add more information and you are able to do so, this is just the base of the query. 

You will notice in the query conditions that organization ID is present twice. The reason for this is that a family may be registered at a different parish but gave to the parish you are pulling information from. This brings us back to the purpose of this query, to 'get family information for parishioners who are registered to a parish and who have given on behalf of that organization.' Please see pictures below on how to build this query. 

 

Results Columns 1

results_1.jpg

 

Results Columns 2 

results_2.jpg

 

Conditions 

conditiions.jpg

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.