Hello Forum!
I appreciate your collaboration to know two things about this tool:
1. In which table or section of the OTRS BD expiration date of a ticket is stored.
2. In which table or section of the OTRS BD closing date of a ticket is stored.
I want to get KPI and compare these fields.
Someone can support me to get this dates??? : shock:
Closedate and Duedate Fields in DB
Moderator: crythias
-
mesaservicio
- Znuny newbie
- Posts: 5
- Joined: 13 Sep 2014, 00:45
- Znuny Version: 3.3.8
- Real Name: Aldo Castro
-
reneeb
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: Closedate and Duedate Fields in DB
1) In dynamic_field_value
2) In ticket_history
2) In ticket_history
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
mesaservicio
- Znuny newbie
- Posts: 5
- Joined: 13 Sep 2014, 00:45
- Znuny Version: 3.3.8
- Real Name: Aldo Castro
Re: Closedate and Duedate Fields in DB
Thanks reneeb,
I found the closedate perfectly in the table that you say, but I can´t find duedate in the table dynamic_field_value.
Can You help me?
Or otherwise I could work with the "time of solution" of each ticket, you know in what table of DB is stored?
I found the closedate perfectly in the table that you say, but I can´t find duedate in the table dynamic_field_value.
Can You help me?
Or otherwise I could work with the "time of solution" of each ticket, you know in what table of DB is stored?