Custom Sorting/Ordering based on a Hidden Column
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).