Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Custom Sorting/Ordering based on a Hidden Column — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Custom Sorting/Ordering based on a Hidden Column

Accepted answer
edited Dec 28, 2017 3:48PM in Reporting & Analytics for B2C Service 7 comments




I have a report based on the "chat_queue_stats_rt" table and would like to create a custom order for the displayed queues (other than alphabetical - I need specific queues to show on top). I was hoping to add a hidden column where I would manually give some queues a value of 1 and other queues a value of 2 and then sort based on this but am getting an error that says: "Non-database fields may be used only as single-column references."

I assume it is because of the table I am using, not sure what can be done to solve it? (I would like to retain the real time values).

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!