Hi All,

Its a very basic requirement in InfoAssist. I need to sort the values in the auto prompt where condition in descending order. Following is the where condition used in the Reporting Object.

  
WHERE ACCT_WON_LOST.EVEST_ASSETS_INFOASSIST_REP_ID.Quarter_End EQ &Quarter_End.(OR(FIND ACCT_WON_LOST.EVEST_ASSETS_INFOASSIST_REP_ID.Quarter_End IN ACCT_WON_LOST)).Reporting Quarter:.;

Any help much appreciated.

Aravindan

This message has been edited. Last edited by: Kerry,

Hello people,

Sending out a big SOS .
Any suggestions.

Aravindan

Assuming the underlying table is on a relational database server, you can have the DBA set up a view that returns a sorted list, and reference that in the FIND() function.