This addresses an issue where row conditions are working in the preview but
not in the actual ticket queue. This updates the `getQueue()` function to
lookup the CustomQueue by `queue_id` if there is no CustomQueue object found
in the QueueColumn.

If an Agent has the Miscellaneous setting checked to see all Tickets in search results, they should be able to see the list of Tickets regardless of their access or if the search is saved or not. They should NOT, however, be able to view those Tickets.

This commit adds 'TicketStatus / Status Name' to the main search criteria list for advanced searching.

This removes a significant number of queries used to render the drop-down
menu for the queues.

Each queue displayed on the page previously required a database query to
determine its children. This patch changes the strategy to fetch all the
queues and organize them as a tree. The tree can then be walked as the menu
is rendered and does not require any further queries.

On my test system, it reduces the number of queries for the ticket listing
page from 56 to 46.

This might happen if the close date was added to a queue and filtered
through a date/time filter.

Also fix warning emit when editing queue configuration

Also fix a few crashes if there is a naming mismatch on the field named in
search criteria and the current name of the field. And fix a regression
where the queue criteria would not be properly updated when saved.

If a queue inherits columns from a parent, the conditions would also be
inherited. This fix changes the association by linking the inherited
column to the child queue at run-time. This allows the queue column to
fetch the queue conditions from the child queue which inherited the
columns.

Check 'inherit columns' checkbox when cloning a queue

Fix doubled saved search listing

This addresses an issue where class Queue sets SavedSearches flags to
`FLAG_QUEUE` causing the SavedSearches to become Primary Queues.

This commit addresses an issue where saved searches were not being ported to
SavedQueues on 1.10.x upgrade to 1.11.x

Make subjects bold (by default) when ticket is unanswered

Add ticket reopen count as a column annotation

Addresses issue with agent/assignee sorting

- On ticket edit, only display inactive help topic warning if the ticket has a help topic
- Inline edit file save fix
- Remove future search/filter criteria for datetime fields that can't be in the future
- Fix calculations for 'next 7 days' and 'next 30 days'. They were selecting dates between now and n days AGO instead of between now and n days in the future

COALESCE sort fields when a column has multiple data sources.

This commits adds ability for agents to configure public queues.

* Customize Columns
* Set default sort & quick filter
* Add supplemental filters (criteria)

To support above features this commit also addresses confusing Advanced
Search UI to make it intuitive when dealing with a Saved Queue vs. Saved
Search vs. Adhoc Search

Only ignore visibility constraints on private "searches" when staff is allowed to search the backend.
Access control is strictly imposed on ALL queues including inherited private sub-queues.

Commit 5be0de0d introduced the idea of moving-up old saved searches to make
room for Custom Queues but failed to account for cases where the system
has more than 30 saved searches.

This commit addresses the issue by just re-inserting the old records after
queues are imported. It also adds validates & reformat the search criteria
to make the expected format.

This commit addresses a few lint related issue - notable one is ignoring
undefined methods within source code comments.

* Make saving advanced ticket search intuitive
* Make save separate operation from search (primary)
* Show inherited criteria on parent queue change

Add ability to select fields / columns to export for queues, including adhoc
searches.

* Export all exportable fields by default - for all queues + adhoc searches
* Export Due Date as well as SLA Due Date

Add ability to add sticky export fields for queues.

This allows a queue to define conditions which apply to the entire row, so
that all the columns in a row can react to a particular condition. For
instance, rows in the ticket queue for tickets due in the near future or
assigned to a particular team could be formatted a certain way.

Adds the ability to "Clone" a queue, which would be nice to create a queue
similar to the current one with a couple distinct settings, but also not a
child of the queue. Also adds the ability to add a "Sub Queue" to the current
queue, which will allow easy creation of queues which are pre-configured for
inheritance.

This adds the ability to add a list of avatars to a column in a ticket
queue.

Also, fix queue paths created at installation time.

Also fix SQL issue with the tables installed in the install script

This patch implements Nathan's mockups for adding sorting options to the
custom queues. The sort drop-down feature was added for v1.10. This patch
adds the complex sort dropdown back into the custom queue feature, but also
makes the sorting options customizable.