I have a need in my report to sort by priority, which is stored as text. I would like to sort it as Critical, High, Medium, Low, not alphabetically. Is this possible in InfoAssist (or even App Studio if necessary)?

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

Not sure about InfoAssist, but I would normally create a new field via a DECODE and set the values to the order needed, then sort by that field first (NOPRINTed).

in InfoAssist, go to DATA tab and click DEFINE. Create a field called PR_SORT. On the right top corner of the Define Wizard, you see an icon fx which stands for the functions available in WF. Expand the Data Source and Decoding folder and look down next to last is a function called DECODE. Click that and then follow this syntax:

DECODE PRIORITY(Critical 1 High 2 Medium 3 ELSE 4)

Then sort by PR_SORT NOPRINT