Dear all,
I would like to extract the parent and child ticket in a report but found that there is no such template report in Statistics. So I have type my SQL statement to get the data that I needed. However, can I save this SQL statement as a template for report/ statistics? As I would like to let user to generate the report by themselves and no need to input the SQL.
Here is my SQL statement:
SELECT id as Ticket_ID, title, target_key as Child_ticket FROM
(select id, title from ticket) as ID
left join
(select source_key, target_key from link_relation) as SK
on ID.id = SK.source_key
order by ID ASC
Thanks & regards,
Layla
Store SQL statement as template report
Moderator: crythias
-
- Znuny superhero
- Posts: 889
- Joined: 15 Dec 2016, 15:13
- Znuny Version: All
- Real Name: Emin
- Company: Efflux GmbH
- Contact:
Re: Store SQL statement as template report
Hello Layla,
that is possible by creating a static statistic (Perl programming needed) in OTRS.
However, the documentation for statis statistics is very poor.
Best regards
Emin
that is possible by creating a static statistic (Perl programming needed) in OTRS.
However, the documentation for statis statistics is very poor.
Best regards
Emin
Professional OTRS, Znuny & OTOBO services: efflux.de | efflux.de/en/
Free and premium add-ons: German | English
Free and premium add-ons: German | English
Re: Store SQL statement as template report
Dear Emin,
Thanks for your information. However, the static statistics in my OTRS is greyed out. I am using OTRS 6.
How can I enable it?
Thanks & regards,
Layla
Thanks for your information. However, the static statistics in my OTRS is greyed out. I am using OTRS 6.
How can I enable it?
Thanks & regards,
Layla
You do not have the required permissions to view the files attached to this post.
-
- Znuny superhero
- Posts: 889
- Joined: 15 Dec 2016, 15:13
- Znuny Version: All
- Real Name: Emin
- Company: Efflux GmbH
- Contact:
Re: Store SQL statement as template report
Hello Layla,
you have to create a custom Perl module in Kernel/System/Stats/Static/
Example
Best regards
Emin
you have to create a custom Perl module in Kernel/System/Stats/Static/
Example
Best regards
Emin
Professional OTRS, Znuny & OTOBO services: efflux.de | efflux.de/en/
Free and premium add-ons: German | English
Free and premium add-ons: German | English
Re: Store SQL statement as template report
Dear Emin,
Thanks for your reply. But it seems a little bit difficult. ><
Regards,
Layla
Thanks for your reply. But it seems a little bit difficult. ><
Regards,
Layla