Hi
We make a report on QlikView.
In order to understand the expired application or not, we need to take into account the production calendar.
The question in which table of the OTRS 6 database is a calendar with marked dates of holidays and holidays?
Or are these data stored in the OTRS itself in files, but are not they in the database?
Thank you
Where is the calendar with the marked dates of holidays and days off?
Moderator: crythias
-
- Znuny newbie
- Posts: 3
- Joined: 05 Sep 2018, 17:25
- Znuny Version: 6.0.4
-
- Administrator
- Posts: 3934
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Where is the calendar with the marked dates of holidays and days off?
Hi,
There is not own table for this. Calendar setting are System Configuration settings. Since OTRS 6 these settings are store in the database but not really usable in queries. Why don't you use a report (TicketList) containing all calculations and use this a a datasource for QlikView?
- Roy
There is not own table for this. Calendar setting are System Configuration settings. Since OTRS 6 these settings are store in the database but not really usable in queries. Why don't you use a report (TicketList) containing all calculations and use this a a datasource for QlikView?
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
- Znuny newbie
- Posts: 3
- Joined: 05 Sep 2018, 17:25
- Znuny Version: 6.0.4
Re: Where is the calendar with the marked dates of holidays and days off?
root, thank you for your prompt response
Sorry for the long answer.
The point is that we have configured the QlikView connection directly to the OTRS database. I.e QlikView receives the necessary data from the database.
We had difficulties at the stage of determining when to consider the ticket as "overdue".
Answering your question. You can try to upload the report file from OTRS and QlikView will take data from this file, but the report in QlikView will in this case not be automatic. Since TicketList will have to be unloaded manually (or modify the OTRS core, which is difficult). In addition, I would like to have one source - the OTRS database.
Sorry for the long answer.
The point is that we have configured the QlikView connection directly to the OTRS database. I.e QlikView receives the necessary data from the database.
We had difficulties at the stage of determining when to consider the ticket as "overdue".
Answering your question. You can try to upload the report file from OTRS and QlikView will take data from this file, but the report in QlikView will in this case not be automatic. Since TicketList will have to be unloaded manually (or modify the OTRS core, which is difficult). In addition, I would like to have one source - the OTRS database.
-
- Administrator
- Posts: 3934
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Where is the calendar with the marked dates of holidays and days off?
Hi,
You won't get the result you like as easy as you expect. I you insist if the OTRS database as a datasource I see only one approach which isn't very hard to implent:
P.S. That's the value in the database for the setting TimeWorkingHours::Calendar1
You won't get the result you like as easy as you expect. I you insist if the OTRS database as a datasource I see only one approach which isn't very hard to implent:
- Create a ticket list report containing all data you need
- Run this report via cron on a regular base creating a csv file
- Take this file and create/update a table from it
- use this table for QlikView
P.S. That's the value in the database for the setting TimeWorkingHours::Calendar1
Code: Select all
Fri:
- '8'
- '9'
- '10'
- '11'
- '12'
- '13'
- '14'
- '15'
- '16'
- '17'
- '18'
- '19'
- '20'
Mon:
- '8'
- '9'
- '10'
- '11'
- '12'
- '13'
- '14'
- '15'
- '16'
- '17'
- '18'
- '19'
- '20'
Sat: []
Sun: []
Thu:
- '8'
- '9'
- '10'
- '11'
- '12'
- '13'
- '14'
- '15'
- '16'
- '17'
- '18'
- '19'
- '20'
Tue:
- '8'
- '9'
- '10'
- '11'
- '12'
- '13'
- '14'
- '15'
- '16'
- '17'
- '18'
- '19'
- '20'
Wed:
- '8'
- '9'
- '10'
- '11'
- '12'
- '13'
- '14'
- '15'
- '16'
- '17'
- '18'
- '19'
- '20'
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
- Znuny newbie
- Posts: 3
- Joined: 05 Sep 2018, 17:25
- Znuny Version: 6.0.4
Re: Where is the calendar with the marked dates of holidays and days off?
root, thanks for the explanation.
That variant of the solution of the problem that you wrote us was considered.
But we came to the conclusion that it is easier to implement the production calendar directly in QlikView. There also to calculate the tickets that were overdue.
That variant of the solution of the problem that you wrote us was considered.
But we came to the conclusion that it is easier to implement the production calendar directly in QlikView. There also to calculate the tickets that were overdue.