Most Recent Performance in Output set

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

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.