Hi everyone!
Has anyone been able to add Most Recent Performance Date to output set elements? I tried copying and updating the line related to the most recent contribution, but that didn't work.
Thanks in advance!!
Hi Kari!
I have an output element that provides a constituent's last performance name and date in one cell, and then if necessary I split them into separate columns in excel. If you think that might work for you, then feel free to try this out in your Test system:
In TR_QUERY_ELEMENT_GROUP, I have a group we called "Last Performance," which uses:
Data From:
T_TICKET_HISTORY
Data Where:
perf_dt < GETDATE() order by perf_dt desc
In TR_QUERY_ELEMENT, we use the following for the Data Select field:
top 1 CONVERT(varchar,perf_dt,1) + ' ' + perf_name
Best,Darryl
Darryl,
That worked perfectly! Exactly what I was looking for, thank you so much for sharing!
You are very welcome! Glad I could help.