This changes the storage model for datetime fields and stores them in the
same format as the MySQL `datetime` column type. This allows for the
searching code to be consistent when searching the database for
datetime custom form entry data.

Change orgs listing to ORM
Add cdata tables support for users and organizations

Make tasks actions icon based buttons
Fix task assignment issue

This changes the typeahead to redirect directly from the typeahead click
rather than redirecting after performing the search a second time on the
ticket queue page.

Use CsvImporter util to importing items
Fix items search

Add preference to agent's profile to enable relative time use.

Let textarea widgets parse and clean input based on configured text format.
Add cleanup routine to ThreadEntryBody
Clean response/note inputs

Implement auto focus and scroll when post reply or note action button is
clicked as well as tab highlight on error
Unpack tickets' mass action buttons - more options retired for now
Translate missed phases

Removed the span, it was unnecessary and gave the Internal Note button
a color to differentiate between Reply and Internal Note.

Moved buttons above with other action buttons and also into sticky
header. Removed titles of buttons and added tooltips. adjusted tooltip
z-index so it won’t be hidden behind dropdowns. added scroll to bottom
function to reply and internal note buttons.

Adds an additional location for the ticket response above the ticket
thread for a reverse order view of the ticket thread. Additionally the
reply/internal note button would be selected and the page would auto
scroll to the bottom.

ClaimForm extends AssignmentForm and hides assignees selection. Claimant is
still given the opportunity to log an optional internal note as to why
they're claiming the ticket in question.

This is necessary to differentiate true system notes vs. notes made by a
deleted agent or collaborator.

Include collaborated tickets
Pagenate user and org tickets listing
Add ability to export tickets

This fixes a bug where the browser will fail to redirect away from
the login page if the client's browser doesn't allow for location
mutations with the 422 response code.

This issue only impacts SSO auth plugins.

Load and cache all the attachments on a thread prior to rendering the items.
That removes the need to run a query per thread item to check for- and fetch
attachments.

#2557 Avatar height issue in Safari.

Also, if searching for multiple words, highlight each word found

This time, use full-text for user and ticket lookup boxes, and drop the
full-table scans from the ticket basic search page. Auto promote searches to
wildcard searches when searching with the user-supplied input yields no
results.

Also, apply requested state to the user and organization tickets search.

If the subject field is something crazy, such as an HTML field, ensure that
the layout of the ticket queue is preserved and properly truncated.
Furthermore, ensure that the HTML is properly rendered on the client and
staff ticket view pages.

The system would encode 'access -related' as 'access+-related' when changing
the sorting preference and would crash the query. This patch fixes the
search engine code to avoid a BOOLEAN MODE search when improper operators
are used in the query terms, and it fixes the sorting preference system to
properly decode the '+' to a space when rewriting the URL.

Adjusted all tables to use % instead of px.

Styled dashboard page.

FAQ tweaks: fixed buttons, adjusted layout for all pages concerning FAQ, resolved Consistency issues.