No matter how I sort my data in the database (in my case I sort it my date, Newest to Oldest) - the data in table on the live page is in the order of creation date. (It’s a dynamicdataset Category page)
When you sort the data in the database that is for viewing only and have no effect on how the data is displayed on your category page. That sort has to be setup on the dataset Dynamic Dataset on your page. If you click Manage Dataset and then scroll down to sorting, that’s where you set the sorting on your page. Happy coding!
Can you please update this answer? There is no longer an item that is “manage dataset”. I’m having the same problem - the sorting keeps flicking back to the opposite of the order of creation. I think there have been changes. I am adding the items in a table; its not a dynamic page.