cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Get most recent modified application

Solved
Highlighted
MEGA Partner

Get most recent modified application

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?

3 Replies
Highlighted
MEGA

Re: Get most recent modified application

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

MEGA Partner

Re: Get most recent modified application

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?

 

 

 

 

Highlighted
MEGA

Re: Get most recent modified application

no the ERQL syntax does not support aggregation or sort.

 

But what I suggested work even in you case