Query results do not show Registration Fee Date Paid for registrations when participant has multiple registration fees on a registration

Outputting Registration Fee Date Paid in query does not show results for Date when the participant has multiple registration fees present on a registration.

Because the date paid could be coming from gifts given on different dates, the Date Paid shows up as blank. To show the date that a gift was given to apply to Registration Fees:

Include the field Registration Fees > Linked Gifts > Gift Date. 

Steps to Duplicate

  1. Create Event or Open existing event record

  2. Create Registration for constituent

  3. Create 2 separate registration fees on the participant record.

  4. Create 2 gifts

  5. Link each gift to event registrations for participant in Event (both gifts show in Linked gifts)

  6. Save and close

  7. Create Participant query

Criteria:

Event name equals [name of event]
AND registration equals Registered

Output:

Name
Participant registration
Registration fee amount paid
registration fee date paid
registration fee gift amount
registration fee number of units

Results
Ouput shows Name, Registration, Fee amount paid, gift amount and number of units.

Registration Fee Date Paid is empty

 

 

Environment

 Raiser's Edge

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.