PSDio IQ - How to build a query for unfulfilled pledges within your specified date range and your specified organization

How to build a query for unfulfilled pledges within your specified date range and your specified organization

The following query will return pledge information for pledges that have not yet been paid off. The query is built to report pledges per a specified date range, to (a) specified fund(s) and to a specified OBO.

A couple things about this query:

  • You can add additional fields to the Result Columns to get family information, but you will want to keep the pledge information at the beginning.
  • You can choose to not have this per organization or per fund if you would like, just take those conditions out of the query.
    uery.jpg

 

If you found this article helpful please give a thumbs up below and if you found that there are things missing please leave a comment so that we can update the article


Related Articles

How to add, remove, or replace a column

How to add, edit, or remove a condition 

 


3767 Ranchero Drive, Suite 100 | Ann Arbor, MI 48108 | Toll Free 866.930.4774 | Fax 734.205.1011
www.parishsoft.com


 Top

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.