Default Sort Order in Interactive Grid

I have an Interactive Grid, and I would like the grid to show the latest date records on top. However, Interactive Grid doesn't support Order by in the SQL.

Is there any way I can have these sorts applied by default, instead of user need to sort these reports by himself?

Also, I don't want to use Save Report as a developer as there are more than 400 reports in our application. Is there a programmable way to implement this?

Manually, you can:

• Open the Oracle APEX Builder and make sure you are logged in as developer
• Run the Page with the Interactive Grid in the browser and log in with the same credentials
• Apply an order by on one (or more) of the columns
• Click 'Actions' -> 'Report'-> 'Save'
• You should see the confirmation "Default report saved for all users"

Programmatically, you can't:

In APEX 20.1 there is a PL/SQL API available, APEX_IG. But currently it doesn't contain functionality what you're looking for..

New functionality will probably be added in future versions of APEX, but that's a guess and surely not something you can use right now.