Hi Friends!
Has anyone been able to get Most Recent Performance Date in an output set? I tried to mimic the Last contributions setup, but that didn't work.
Any help is appreciated!
Depending on your needs, it should be pretty simple to set up an entry in TR_QUERY_ELEMENT_GROUP to pull the most recent entry from VS_TICKET_HISTORY. or VS_ELEMENTS_TICKET_HISTORY. In the Data From column, (select top 1 * from VS_TICKET_HISTORY order by perf_dt) should do the trick.