Changes between Version 1 and Version 2 of ViewingAllSupportTickets

Timestamp:

01/22/26 04:14:55 (15 hours ago)

Author:

221296

Comment:

--

ViewingAllSupportTickets

@@ -3 +3 @@
 ==== Actors: **Administrator (ADMIN)**
 
-**1.** The admin selects All Tickets.
+**1.** Accessing the Support Ticket Overview.
 
-**2.** The system returns all tickets ordered by creation time.
+**2.** Retrieving All Support Tickets.
 
 
 {{{#!sql
-SELECT ticket_id, subject, status, created_at
-FROM support_ticket
-ORDER BY created_at DESC;
+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;
+
 }}}