Incorrect results when querying or exporting the Gift Vehicle Bequest

When creating a query including Criteria such as 'Gift Vehicle equals Bequest', users expect the results to display Planned Gifts with a Vehicle type of Bequest.  However, the results display gift types other than Planned Gifts.  When querying on Gift Vehicle of another type, the results display only Planned Gifts with the corresponding Gift Vehicle. In addition, when exporting Gift Vehicle, the field populates with 'Bequest' for all non-Planned gifts. Although the Vehicle field does not exist on non-Planned gifts, this is still the default value that is used in query and export.

Gift Vehicle will populate with Bequest for Gift Types that are not Planned Gifts from Query or Export.  
This issue will not be addressed in Version 7 of The Raiser's Edge.
The program is working as designed.  The default value of Gift Vehicle is Bequest.  Non-Planned Gifts will receive the default value in the results of query or export.

Alternate solutions:

In query:

Add the following field to the Criteria:
Gift Information, Gift Type equals Planned Gift

In export:
  1. Add the following field to the Output:
    Gift Information, Gift Type
     
  2. Once the file is exported to Excel, sort the spreadsheet by Gift Type and delete the Gift Vehicle value for all non-Planned gifts.

Environment

 7.91.5056, patch 18

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.