KevinTheJedi
Hi!
I have the same problem.
osTicket 1.12
To reproduce, you have to have tickets both with "Due Date" automatically filled by SLA Plan ("Due Date" has not been manually edited) and tickets with "Due Date" manually edited.
As Queue column "Due Date" formed by 2 data sources (primary - Due Date, secondary - SLA Due Date (if primary is empty)), but Queue Sorting does not, thus Sort by Due Date working not correctly (column sorted by "SLA Due Date" only).
Sorting options must have the same logic (primary and secondary source for sorting) to working properly, or must refer to resulting values of "Due Date" column.
For clarity, I create custom queue with 3 Due Date columns:
1 - SLA Due Date - primary source "SLA Due Date", secondary source - empty,
2 - Due Date - primary source "Due Date", secondary - empty,
3 - Resulting Due Date - primary source "Due Date", secondary - "SLA Due Date" (as in original queue config).
In my example Due Date sorting refers to "SLA Due Date" field, so "SLA Due Date" column looks good sorted, but not "Resulting Due Date".
We see empty cells in "Due Date" column.
Neither sort by "SLA Due Date" nor "Due Date" does not give the expected result in "Resulting Due Date".
