Skip to main content

Sample Queries

Fetching Tags for a Ticket​

SELECT t.name, t.color
FROM Tags t
JOIN TicketTags tt ON t.id = tt.tagId
WHERE tt.ticketId = 1;

Fetching Tickets with a Specific Tag​

SELECT tk.*
FROM Ticket tk
JOIN TicketTags tt ON tk.id = tt.ticketId
JOIN Tags t ON tt.tagId = t.id
WHERE t.name = 'Urgent';

Fetching Participants of a Ticket​

SELECT p.*
FROM Participants p
WHERE p.ticketId = 1;

Fetching Parent Tags of a Tag​

SELECT pt.name
FROM TagsParentTags tp
JOIN Tags t ON tp.tagId = t.id
JOIN Tags pt ON tp.parentTagId = pt.id
WHERE t.name = 'Office';