include ticket id (not ticket number) in report

Moderator: crythias

Post Reply
PhyrePhoX
Znuny advanced
Posts: 132
Joined: 05 Dec 2007, 10:56
Znuny Version: 5.0.24 (with ITSM Mo

include ticket id (not ticket number) in report

Post by PhyrePhoX »

Hi,

i would like to have the ticket ID included in reports (x-axis), not just the ticket number.

Do you know if there is a way?

Thank you!
OTRS 5.0.24 (with ITSM Modules) and Znuny 6.4.4 in staging
PhyrePhoX
Znuny advanced
Posts: 132
Joined: 05 Dec 2007, 10:56
Znuny Version: 5.0.24 (with ITSM Mo

Re: include ticket id (not ticket number) in report

Post by PhyrePhoX »

are you implying i just need to uncomment this line? What comes after that (i usually try to avoid editing in the filesystem directly)? Do i just restart apache or do i have to rebuild config, or "just" clear cache? Thanks!
OTRS 5.0.24 (with ITSM Modules) and Znuny 6.4.4 in staging
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: include ticket id (not ticket number) in report

Post by root »

Hi,

I think he talks about editing. It's recommended to copy the original files you like to modify to the Custom/ folder (including directories). In your case:

/opt/otrs/Kernel/System/Stats/Dynamic/TicketList.pm => /opt/otrs/Custom/Kernel/System/Stats/Dynamic/TicketList.pm

Then modify the file and restart the Apache httpd

- 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 ?
PhyrePhoX
Znuny advanced
Posts: 132
Joined: 05 Dec 2007, 10:56
Znuny Version: 5.0.24 (with ITSM Mo

Re: include ticket id (not ticket number) in report

Post by PhyrePhoX »

root wrote: 17 Jun 2022, 11:58 Hi,

I think he talks about editing. It's recommended to copy the original files you like to modify to the Custom/ folder (including directories). In your case:

/opt/otrs/Kernel/System/Stats/Dynamic/TicketList.pm => /opt/otrs/Custom/Kernel/System/Stats/Dynamic/TicketList.pm

Then modify the file and restart the Apache httpd

- Roy
thanks for the reply. If i dont copy the file, i guess it will be overwritten when i patch otrs. And when i copy, OTRS will search for the file first in the custom folder. Okay, got it - thanks!
OTRS 5.0.24 (with ITSM Modules) and Znuny 6.4.4 in staging
PhyrePhoX
Znuny advanced
Posts: 132
Joined: 05 Dec 2007, 10:56
Znuny Version: 5.0.24 (with ITSM Mo

Re: include ticket id (not ticket number) in report

Post by PhyrePhoX »

It worked. Thanks again, people!
OTRS 5.0.24 (with ITSM Modules) and Znuny 6.4.4 in staging
PhyrePhoX
Znuny advanced
Posts: 132
Joined: 05 Dec 2007, 10:56
Znuny Version: 5.0.24 (with ITSM Mo

Re: include ticket id (not ticket number) in report

Post by PhyrePhoX »

PhyrePhoX wrote: 19 Jun 2022, 18:35 It worked. Thanks again, people!
Actually, i was too fast...

I can choose TicketID in the X-Axis now (and also OwnerID, i uncommented that one in TicketList.pm as well), but in the resulting file, both these columns are missing :(

You see in x-axis "selector" i added ticketid and owner id
Screenshot from 2022-06-19 18-39-44.png
But in the preview, this is disregarded:
Screenshot from 2022-06-19 18-39-57.png
Also in the description of the stat:
Screenshot from 2022-06-19 18-38-06.png
What could that be?
You do not have the required permissions to view the files attached to this post.
OTRS 5.0.24 (with ITSM Modules) and Znuny 6.4.4 in staging
PhyrePhoX
Znuny advanced
Posts: 132
Joined: 05 Dec 2007, 10:56
Znuny Version: 5.0.24 (with ITSM Mo

Re: include ticket id (not ticket number) in report

Post by PhyrePhoX »

t tried to find something in a tt or dtl file, but didnt. Where else can i look? or do i have to rebuild config?
OTRS 5.0.24 (with ITSM Modules) and Znuny 6.4.4 in staging
PhyrePhoX
Znuny advanced
Posts: 132
Joined: 05 Dec 2007, 10:56
Znuny Version: 5.0.24 (with ITSM Mo

Re: include ticket id (not ticket number) in report

Post by PhyrePhoX »

anyone? There are more options uncommented in the ticketlist.pm file, so i guess there must be an easy way to make them available?
OTRS 5.0.24 (with ITSM Modules) and Znuny 6.4.4 in staging
skullz
Znuny superhero
Posts: 618
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: include ticket id (not ticket number) in report

Post by skullz »

Also add TicketID within 'SortedAttributes' array

https://github.com/znuny/Znuny/blob/df0 ... t.pm#L1750

Code: Select all

 
my @SortedAttributes = qw(
 Number
 TicketNumber
 (+) TicketID
  Age
  Title
  .......
  .........
  ),
PhyrePhoX
Znuny advanced
Posts: 132
Joined: 05 Dec 2007, 10:56
Znuny Version: 5.0.24 (with ITSM Mo

Re: include ticket id (not ticket number) in report

Post by PhyrePhoX »

skullz wrote: 23 Jun 2022, 05:56 Also add TicketID within 'SortedAttributes' array

https://github.com/znuny/Znuny/blob/df0 ... t.pm#L1750

Code: Select all

 
my @SortedAttributes = qw(
 Number
 TicketNumber
 (+) TicketID
  Age
  Title
  .......
  .........
  ),
thanks alot, that did the trick!!!. Dont even have to reload apache.
OTRS 5.0.24 (with ITSM Modules) and Znuny 6.4.4 in staging
Post Reply