To find constituents that have given a tribute gift:
 

  1. Create a constituent query.
  2. On the Criteria tab, select Gifts > Tribute Gift equals Yes
    Note: To find the number of constituents that gave a tribute gift, create a static constituent query using the above criteria. When the query is saved, the number of keys generated is the number of constituents that gave a tribute gift.


To find constituents that have given a tribute gift to a specific tribute name:

  1. Create a constituent query.
  2. On the Criteria tab, select Gifts > Tributes > Honor/Memorial Name equals [the tribute name]


To find constituents that have given a tribute gift based on the deceased date of the Memorial Name:
For example, find constituent who have given a tribute gift for anyone who passed away since a certain date

  1. Create a constituent query.
  2. On the Criteria tab, select Gifts > Tributes > Tribute Constituent Record > Deceased Date greater than or equal to [specific date]


To find constituents that gave to specific tribute(s) but not to other tribute(s):

  1. Create a constituent query (Query A). On the Criteria tab, select Gifts > Tributes > Honor/Memorial Name one of [specific honor/memorials]
  2. Create another constituent query (Query B). On the Criteria tab, select Gifts > Tributes > Honor/Memorial Name one of [all other honor/memorials]
  3. Merge the queries with Query A as the primary, Query B as the secondary, and SUB as the operator. 


To find constituents that gave only tribute gifts:

  1. Create a constituent query (Query A). On the Criteria tab, select Gifts > Tribute Gift equals Yes
  2. Create a constituent query (Query B). On the Criteria tab, select Gifts > Tribute Gift equals No
  3. Merge the queries with Query A as the primary, Query B as the secondary, and SUB as the operator


To find constituents that gave only one gift and that gift was a tribute gift:

  1. Create a constituent query
  2. On the Criteria tab, select:
    Summary Information > Summary for Gift > Total Number of Gifts equals 1
    AND Gifts > Tribute Gift equals Yes
  3. On the Criteria tab, select:
    Summary Information > Summary for Gift > Total Number of Gifts equals 0
    AND Gifts > Tribute Gift equals No
  4. Change the second Gift Total Number of Gifts filter from OR to AND. 


To find constituents that gave a tribute gift in a specific date range:

  1. Create a constituent query
  2. On the Criteria tab, select:
    Gifts > Tribute Gift equals Yes
    AND Gifts > Gift Date between [the date range]


To find constituents that gave a specific amount in tribute gifts:

  1. Create a constituent query
  2. On the Criteria tab, select:
    Summary Information > Summary for Gift > Total Amount [select the appropriate operator and amount(s)]
    AND Gifts > Tribute Gift equals Yes
    * For more information on selecting and filtering Summary Information fields in query, refer to BB237530.


To find gifts given to a specific honor/memorial type:

  1. Create a gift query.
  2. On the Criteria tab, select Tributes > Honor/Memorial Name equals [tribute name].