Get most recent modified application

[rizwanghafoor]

I am trying the below query to get the most recent modified application

Select [Application] where [Modification Date] <= "&CurrentDate"

I need to order/sort the result by the [Modification Date] and limit the result to just 1 application

How can we add these operators to get our required result?

[oguimard]

no the ERQL syntax does not support aggregation or sort.

But what I suggested work even in you case

[rizwanghafoor]

I am using query tool to run the query from the windows front-end.

can we simply add the operators in the query it-self?

[oguimard · Accepted solution]

How do you execute the query ?

If this query is in a macro you can sort with the getSelection() that take into parameter the date. Then you can loop only on the first item of the collection.

My suggestion is to convert your query object into a query macro, put your ERQL query in a VB script and do as said above