Hi,
In a subject query filter, I have to add the filter to get of data like below and I need to get only the latest rows based on the update date.
DATA
CASE ID LAST SYSTEM UPDATE
1111 09/09/2016
1111 08/09/2015
1222 09/09/2016
1222 07/09/2015
So trying to get the following row in the Subject Query:
RESULT
1111 09/09/2016
1222 09/09/2016
Could you please help!
Thanks so much for your time.
Ok, I'm using the following,
QuoteLAST SYSTEM UPDATE = maximum(LAST SYSTEM UPDATE for CASE ID )
What do you think? This should give me
all the records but only the
most up-to-date ones based on
CASE ID. Right?
Thx
Quote from: gosoccer on 02 Sep 2016 10:56:11 AM
Ok, I'm using the following,
What do you think? This should give me all the records but only the most up-to-date ones based on
CASE ID. Right?
Thx
Correct :)
Thanks for confirming. Works great!