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
12
Views
7
Comments
edited Dec 28, 2017 3:48PM in Reporting & Analytics for B2C Service 7 comments

Content

Hi,

 

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.

Register

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