Viewing All Support Tickets (Admin)

Actors: Administrator (ADMIN)

1. Accessing the Support Ticket Overview.

2. Retrieving All Support Tickets.

SELECT t.ticket_id,
       ue.first_name || ' ' || ue.last_name AS user,
       t.subject, t.status, t.created_at
FROM support_ticket t
JOIN users u ON t.user_id = u.id
JOIN user_entity ue ON ue.id = u.id
ORDER BY t.created_at DESC;

3. Updating the Ticket Status.

UPDATE support_ticket
SET status = 'RESOLVED'
WHERE ticket_id = :ticketId;