Skip to Main Content
  • Questions

  • changing default sort order for users on Interactive Reports

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Ricardo.

Asked: July 06, 2023 - 8:06 am UTC

Last updated: July 10, 2023 - 5:42 am UTC

Version: Oracle APEX 23.1

Viewed 1000+ times

You Asked

I get to sort and display or hide columns. But only for my report, that is I log into the created app with my admin account, I am able to sort and hide columns. But I have no option to set that final result as the default report. I always get a new report which I save and becomes the default FOR ME. But not for the users. The users still see the default report.
How can I make users see what I see. For example the report order on date ascending, not Last name.
I tried the SQL part in the form, using the field name and "asc" but it just doesn't work.

and Connor said...

Run your report from the builder, customise it how you like and then choose Report => Save

Then you can choose to make this the default for all users

APEX_PRIMARY

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.