671
Views
4
Comments
Solved
How to set order for Combo box item
Question

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.


2019-11-25 11-21-58
Ana Reis
 
MVP
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

2017-05-22 08-54-43
Benji

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

2025-08-22 10-19-44
Pramod Jain
 
MVP

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-

2017-09-19 10-08-14
Sekar

Hi Ana,

Thanks.


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.