How to add a hyperlink to the ticket in excel report

[egraves]

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!

[root]

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

[apolloit]

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.

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'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.

[root]

Hi Michael,

It's possible to use the ticket number for the link:

/otrs/index.pl?Action=AgentTicketZoom;TicketNumber=xxxxxx

- Roy

[apolloit]

Hi Michael,

It's possible to use the ticket number for the link:

/otrs/index.pl?Action=AgentTicketZoom;TicketNumber=xxxxxx

- Roy

That's absolutely brilliant - and just what I needed. I can now process a URL.

Thank you Roy!!

Michael.