How do I sort the rows in TXDataWebDataSet

BIZ TMS XData
1

Using XData and TMS WebCore. There is one table that I need to fetch to put into a DBLookupCombo, but ordered by a particular indexname.

  1. I would prefer to do this on the server. Is there a way to do this server side? I am happy to create a duplicate Entity with a different name, if that is a solution.
  2. I cant find any property on TXDataWebDataSet for sort or index. How can I achieve this?
2

If you are using the automatic CRUD endpoints, you can use the $orderby filter option: