I’ve been trying to figure out why an app is sorted by an ID field instead of the ORDER BY in my SQL statement. Oddly, the SQL works as expected in the Workbench and Database Builder. However, the running the app with the same SQL simplifies the ORDER to the ID field.
Tinkering with this for a couple of hours, I’ve rebuilt the app and found that once I remove the RUN button the query displays correctly. Put the RUN Button back in place, even with a “Hello World” statement, it reverts back to the sort by ID.
Any idea how to remedy this issue?