Skip to main content

Exclude Tickets Created by Agents

in Example Reports
Authors list
Diterbitkan: 16 Mar 2017|Last updated: 3 Nov 2022

Requirement: create a report on tickets created by users, not including tickets created by agents.

You can use tickets.creation_system to select tickets by how they were created.

The possible values are:

Value

Description

gateway.person

User email

gateway.agent

Agent email (ie forwarded)

web.person.portal

User portal

web.agent.portal

Agent interface

web.api

DeskPRO API

To match just user created tickets, your query could include:

WHERE tickets.creation_system LIKE '%person%'
copy
MembantuUnhelpful

0 of 1 people found this page helpful

next pageExporting User Data
previous pageChat Widget Feedback

Please log in or register to submit a comment.