SELECT
Guid, TicketNumber, Subject, Description,
Status, Priority, TicketType,
AssignedTo, RequestedBy,
CreatedDate, SlaResolutionDeadline,
SlaResolutionMet, EstimatedDate
FROM data_ticket
WHERE Package = '{package}'
AND Status NOT IN ('CLOSED', 'CANCELLED')
ORDER BY
FIELD(Priority,
'CRITICAL','HIGH','MEDIUM','LOW','INFO'),
CreatedDate ASC
SELECT DISTINCT AssignedTo
FROM data_ticket
WHERE Package = '{package}'
AND AssignedTo IS NOT NULL
AND AssignedTo != ''
AND Status NOT IN ('CLOSED', 'CANCELLED')
ORDER BY AssignedTo
SELECT DISTINCT TicketType
FROM data_ticket
WHERE Package = '{package}'
AND TicketType IS NOT NULL
AND TicketType != ''
AND Status NOT IN ('CLOSED', 'CANCELLED')
ORDER BY TicketType