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?
Solved! Go to 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
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?