How to find all donors who have a specific recurring gift schedule frequency

When we set a Recurring Gift Schedule in eTapestry, we have to select a Frequency for the Recurring Gift. We can create a query to find all donors who have a specific Frequency on their Recurring Gift Schedule. For example, we can find all donors who have a monthly Recurring Gift Schedule.

Article
Number:105969

Products:

eTapestry

Click Queries

Click Manage Queries

Select the category where you would like to store this query

Select New Query under the Tasks menu

Name the query

Set the Starting Query to Base/All Constituents

Set the Data Return Type to Journal Entries

Under Criteria Matching select Match Each Criteria

Select Journal from the Browse Fields drop down menu and click on Transaction Schedule Frequencies