Hello ARAS community,
once again o would have your advice.
to be clear, this is what we have in the table of an object :
id REF_NUMBER_ MODIFIED_ ON STATE IS_CURRENT MAJOR_REV
2154BB99E5F046 B 2019-11-06 09:43:54.560 Working 1 A
2A7B8BD203A54C C 2019-11-06 09:44:03.450 Working 1 A
5E2A1CD82CD14A A 2019-11-06 09:45:41.210 Saved 1 A
B3CE5360E24449B A 2019-11-06 09:43:48.837 Working 0 A
I need as a result to get the line 1, 2 and 4. this correspond to get all the object at the state Working and only the most recent one.
My problem is if i use as filter (state = 'working') AND (is_current = 1) i only get line 1 and 2. the 3 cannot be segregated.
Is it possible ?
Thank you :)