Can i add an "Order" filed in custom lookup data table ?

[yandp]

Hi all, 
in my custom application some field are using reference field to the custom lookup data .

Can i add an order field in custom lookup table and use that to sort the keywords list retrieved from the custom lookup data?

If yes, please share how to do else any other method to achieve this?

Thank you so much.

[Sagar Pagar]

Hi @yandp,

Yes. you can add the order/ sequence field or column. You can use it in reference qualifier to sort it ascending or descending order.

Qualifier:

^ORDERBYu_order;

^ORDERBYDESCu_order;

Thanks,

Sagar Pagar

[Arun_S1 · Accepted solution]

@yandp you meant to say that some of the OOTB tables like Business Rules, UI Policies contain an order field. You would like to add a similar field in your custom table is it?

You can add the order field in the lookup table and add "ref_ac_order_by=u_order" in your variable attributes field, this will take care of the ordering part.

Note: u_order is my custom field, please change in case you have a different field.

Please mark the appropriate response as correct answer and helpful.

Thanks!!

[yandp]

Hi @Arun_S1 , 

Thank you so much for the help, after adding as your suggestion, it is now working in record producer.
what about in the platform, how to have the sorting based on the order also?

Thank you.

[Arun_S1]

@yandp Please see the screenshot below, please add the attribute "Reference auto completer order by" attribute on the reference field and the value should contain the order field name "u_order".

Please mark the appropriate response as correct answer and helpful.

Thanks!!