Ticket query builder
The Queries tab
The TICKETS menu has two tabs:
- Tickets: the list of tickets, in Kanban or List view, with its filters and bulk actions.
- Queries: the queries on tickets. This tab requires the segmentation permission and a PRO license.
The + button of the menu offers New ticket and New request.
The ticket query builder
The ticket query builder works like the account one: it combines criteria with "AND" and "OR", and lets you save, duplicate and share queries. The query list can be filtered on My queries or Shared queries.
The available criteria cover:
- the ticket: number, title, description, type, status, priority, origin, assignment, creation, due, closing and modification dates;
- the account of the ticket, or else the account of its contact: company name, zip code, city, manager, category, type, sector, origin, potential…;
- the contact of the ticket: last name and first name;
- the ticket custom fields, prefixed by their category.
The Execute button shows the matching tickets. The title of a ticket opens its details. The Action menu exports the selected tickets to Excel or CSV.
The query list shows the criteria of each query in the Criteria column.
Using a query in the ticket list (advanced mode)
The header of the Filters panel of the Tickets tab offers two modes:
- Simple mode: the usual filters (assignment, status, type, priority, creation and closing dates).
- Advanced mode: a ticket query replaces these filters, including the creation period. The simple mode filters are kept and restored when going back to the simple mode.
The advanced mode applies to the Kanban and List views and to the list export. The Query selector only offers ticket queries. The name of the selected query is shown in the list title.
The Edit button lets you adjust the criteria in the panel and Apply them to the list, without changing the saved query. The advanced mode requires the read permission on segmentation.
