You can use IN to create subqueries. For example:
SELECT tickets.id
FROM tickets
WHERE tickets.id IN (
SELECT tickets.id
FROM tickets
WHERE tickets.ref LIKE 'AAAA-%'
) copy- Reports Overview
- DPQL Reference
- Example Reports
- Querying Custom Fields
- Chat Widget Feedback
- Exclude Tickets Created by Agents
- Exporting User Data
- List Tickets Created on the Weekend
- Links to all Tickets each Agent resolved Last Month
- Reports on Billing and Time Log Changes
- Reports using Ticket Logs
- Ticket Backlog with a Custom Timeframe
- Ticket Messages per Agent excluding Notes
- DPQL Field Reference Tables
Please log in or register to submit a comment.