== Viewing All Support Tickets (Admin)

==== Actors: **Administrator (ADMIN)**

**1.** Accessing the Support Ticket Overview.

**2.** Retrieving All Support Tickets.


{{{#!sql
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.


{{{#!sql
UPDATE support_ticket
SET status = 'RESOLVED'
WHERE ticket_id = :ticketId;

}}}