how to set rows with custom order in dropdown Thingworx 9.1.1

[VaibhavShinde]

Hi ,

I have Datatable which contains 20 rows and i have written service which fetch Machine names from this Datatable and displays in Dropdown , but i want order of rows same which is in Datatable. how to achieve this. if we manage it at dropdown also No issue.

Thanks,

Vaibhav 

[PaiChung]

In your service that fetches the data, apply a Sort

[VaibhavShinde]

Hi @PaiChung ,

If we sort in Service, it will return either Ascending or Descending. I want custom order that is how I have inserted in Datatable

in same order dropdown list should hold. If you elaborate more on this , would be better.

Thanks,

[PaiChung · Accepted solution]

If you need to enforce an order, I recommend you add an order field to your DataTable (assuming there is no suitable field to order on available) and then apply sort to that order field.