Order choice on lookup select box variable

[ebaileyybs]

HI,

I have created a lookup select box variable which relates to a field on a table. I would like to sort the choices on the variable to match the order on the form field.

How would I go about doing this?

Thanks in advance.

Emma

[Kalaiarasan Pus]

dont think sorting is possible on this ....

[Anurag Tripathi]

Hi Emma,

This is tricky think, i did this once.

What you need here is a query business rule on the table where your choice values are.

Before

Query

Table - table having choice values

Script:

current.orderBy('<COLUMN THAT YOU WANT TO SORT ON>');

NOTE: but this will be a global change on that table, so u need to be careful that you don't break anything as all the query going to this table will now give sorted result.If this is choice table or your personal table then you can do it without any worries.

[kaireidegeld · Accepted solution]

Hi,

if you have a field in the table for the lookup select box called 'u_order', then use the following reference qualifier: "ORDERBYu_order" in the type specification.

Kind regards,

Kai

[Jeff Shirling]

This doesnt seem to work on the serviceportal.