How to set order for Combo box item

How to set order for Combo box item

  

Hi,

I am using external database in my web application.

Table Data




IdLabelOrder
1Energised1
2De-Energised2
3Exchanged3
4Disconnected4


By default combo box items are ordered alphabetically. I have a column called [order] (INT) in my table.

I want to display the drop-down items based on [Order] Column.


Solution

Hi Sekar,

You can create an aggregate to be the source record list of your combo box and order the results as you need. Or when referencing the entity from external database on you espace you can set the order by attribute field (on more options) to be the Order field. This you filter your records on combox automatically. 


Ana Reis

Solution

Hey Sekar,

I recently had to do this on one of my projects and this help me a lot.

https://success.outsystems.com/Documentation/Development_FAQs/How_to_order_and_set_the_default_value_in_a_combo_box

HI Sekar,

You can write an advance query to get the data based on order by putting an order by clause and assign it to your drop down.



Regards

-PJ-

Hi Ana,

Thanks.