How find queue that Resolved a ticket?
Moderator: crythias
How find queue that Resolved a ticket?
I need to execute a query to find the last queue that set the ticket into status Resolved, Pending, Incomplete, Rejected.
-
- 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?
Hi,
Have a look at ticket history table. I think the event you are looking for is StateUpdate.
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
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