PSDio IQ - How to build a query reporting registered parishioners who have given to a specific fund on behalf of their parish

How to build a query reporting registered parishioners who have given to a specific fund on behalf of their 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 add additional information in the Result Columns window.  

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

 


Related Articles

How to add, remove, or replace a column

How to add, edit, or remove a condition 

 

Top

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.