We are using Dataselect CCE widget to populate values in a dropdown list from a DB table. We are not able to decide on the order in which the values are populated inside the dropdown even after adding ORDER BY clause in the sql query we provide.
We are using com.vignette.wcm.widgets.base.referencedata.SQLReferenceDataImpl this class