Tribute Queries

Kristina Holland

Hello, is it possible to create a tribute query that will export the constituent ID of a tribute's acknowledgee? I can't seem to find the tribute acknowledgee's constituent ID in the output field of a query. I am able to export the tribute's acknowledgee's name and their address but not their constituent ID. Please let me know if this is an output option in RE's 7.96 verion. I greatly appreciate your help!

Thank you!

Kristina Holland

Ryan Hyde

Doesn't look like this is available in Query, but it is available in a gift Export.


Tributes > Acknowledgees > Acknowledgee Record

Steven Cinquegrana 2

Or you could use direct SQL via SQL Server Management Studio (if you're self-hosted).

 

Kristina Holland

Ryan Hyde:

Doesn't look like this is available in Query, but it is available in a gift Export.


Tributes > Acknowledgees > Acknowledgee Record

Hi Ryan,

This is great! Thank you so much for your help!

Appreciatively,

Kristina