How to add a hyperlink to the ticket in excel report
Moderator: crythias
How to add a hyperlink to the ticket in excel report
Hi so I'm somewhat familiar with OTRS, but I want to add an extra column to a report that has a link to the ticket so when viewing the report with the higher ups I can just click on the link to show them what the actual ticket is. Thanks for any help!
-
- Administrator
- Posts: 4011
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: How to add a hyperlink to the ticket in excel report
Hi Eric,
I don't see any chance to get this done with OTRS only. You could try to create a CSV report and modify the file with awk. The other option is commercial add-on.
- Roy
I don't see any chance to get this done with OTRS only. You could try to create a CSV report and modify the file with awk. The other option is commercial add-on.
- 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: 36
- Joined: 01 Jun 2015, 10:17
- Znuny Version: 6.0.28
- Real Name: Michael James
Re: How to add a hyperlink to the ticket in excel report
Hello,
I know I'm waking an old thread, however its the only one I can find that's precisely what I'm after - and figured the info useful to anyone searching later.
My ticket ref format is 8 digits, and the ticket ID is 6 - with no correlation between the two.
Many thanks indeed
Michael.
I know I'm waking an old thread, however its the only one I can find that's precisely what I'm after - and figured the info useful to anyone searching later.
I'm happy to modify with AWK, however how do I extract the ticket-id on the report? I have the ticket reference - but the ID is needed for building the URL. Apologies if I'm missing something really silly.
My ticket ref format is 8 digits, and the ticket ID is 6 - with no correlation between the two.
Many thanks indeed
Michael.
-
- Administrator
- Posts: 4011
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: How to add a hyperlink to the ticket in excel report
Hi Michael,
It's possible to use the ticket number for the link:
/otrs/index.pl?Action=AgentTicketZoom;TicketNumber=xxxxxx
- Roy
It's possible to use the ticket number for the link:
/otrs/index.pl?Action=AgentTicketZoom;TicketNumber=xxxxxx
- 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 ?