Prompt is not appearing in sort order

[Former Member]

Hi All,

Here I am trying to prompt to get the date as user input. It is not appearing in sort order. Always user has to manually sort the prompt window.  Advice how I can handle it automatically/ by default ASC order.

@prompt('Enter value for Trailer Arrived Date (Start):','N','Receiving Data\Trailer Arrived Date',Mono,Free,Persistent,,User:0)

Thanks,

[CdnConnection · Accepted solution]

     You have your LOV properly sorted for the the UNV / UNX.  Choose the Object in the UNV / IDT  go to the properties TAB > EDIT. Now in the Query panel select the Result Objects and then the sort desired (A to Z) or (Z to A).

You also set a GLOBAL setting under the Parameter TAB for connections.

Regards,

Ajay

[Former Member · Accepted solution]

Thank you so much Ajay. Are you talking this global variable. Pls see the attachment.

[CdnConnection · Accepted solution]

  That's NOT the one.  If you don't have, you need to create "FORCE_SORTED_LOV = Yes ", it is CAP sensitive.

Regards,

Ajay

Please let me know if this and previous information was helpful.

[Former Member · Accepted solution]

It is working fine.  Thanks Ajay.