Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I had used the dual function in the list box and it works perfectly. But the sorting is not working. None of the options are not working in sorting. Any one has faced this issue earlier.
Can you share your sample app?
Hi,
You can do sorting by using rank() function for your text field. eg. if you are using dual(Name, ID) then in the sorting expression you may want to put rank(Name) in descending order. This will sort all your selected 'Name' field items in alphabetical order.
Additionally, if you need to sort even the non-selected 'Name' entries too. I will advice you to clear that field itself in the set expression and use '1' identifier before that. eg. rank(only{1<Name=>} Name).Now, it will consider full set of all your 'Name' records.
Hope this will help.
Regards,
Lokesh
Alwyas works for me... Make sure you order by numeric value.
Regards,
Michael