How find queue that Resolved a ticket?

Moderator: crythias

Post Reply
Thommino
Znuny newbie
Posts: 1
Joined: 06 Oct 2017, 19:50
Znuny Version: 3.2.0
Real Name: Thomas

How find queue that Resolved a ticket?

Post by Thommino »

I need to execute a query to find the last queue that set the ticket into status Resolved, Pending, Incomplete, Rejected.
nedmaj
Znuny expert
Posts: 167
Joined: 26 Nov 2014, 20:34
Znuny Version: 6.3.4
Real Name: Samuel Casimiro
Company: Câmara dos Deputados
Contact:

Re: How find queue that Resolved a ticket?

Post by nedmaj »

Hi,

Have a look at ticket history table. I think the event you are looking for is StateUpdate.
Samuel

Znuny 6.3.4 | OTRS 5.0.17
OS: Debian 11 | CentOS 6.5
Database: Postgres | Oracle 12.1
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000
Post Reply