Query Examples
How to create a constituents query
Below is a basic query to pull most used constituent data. You may add additional restrictions in the “Include records where” section depending on the results you want to pull. For example, if you would like to fetch records for constituents that have been added this year, you should include the “Date added” restriction:
How to create a program query
In October 2022, Altru released in this article about a new feature that can be used to query remaining capacity for programs. Feel free to use this field to query the remaining capacity: