Combobox list re-ordering?

Permanently deleted user

March 20, 2015 05:47

The order of the items in a combobox does not adhere to the order by of the SQL statement I used to populate the list (pulling data from SQL Server). It simply orders it ascending no matter what I do. I needed to do descending.

Is there any way to set the order of combobox items?

 

thanks

Rob

0

• 

  Permanently deleted user

  April 22, 2015 23:55

  Rob,

  Could you cut-and-paste your workflow here?

  So you are set 'Input Data' of the ComboBox control as the datasource, which comes from the SQL Select, where you uses Order By Desc, but the UI (ComboBox) does not respect.

  It should respect the Input Data (List<DataItem>).

  Munhwan

  0
• 

  Permanently deleted user

  April 24, 2015 01:07

  Rob,

  You checked 'Sort' on DataTableToDataItemList_Analytes activity, which makes the DataTable (varSampleQuarterSource), which ordered by DESCending as your SELECT query statement, but Re-sorting back to ASCEnding by chekcing SORT check box.

  Please uncheck 'Sort' to honour what your SELECT statement returns.

  Run the workflow on the Desinger, and click F9 to debug the input/output of the activity on DataTableToDataItemList_Analytes activity to debug out on Designer.

  cheers,

  Munhwan Gim

  0
• 

  Permanently deleted user

  April 24, 2015 01:16

  Aha, I never saw that sort box!

  Thanks!

  Rob

  0

Please sign in to leave a comment.