include ticket id (not ticket number) in report

[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!

[skullz]

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

[PhyrePhoX]

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

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!

[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

[PhyrePhoX]

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!

[PhyrePhoX]

It worked. Thanks again, people!

[PhyrePhoX]

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?

[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?

[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?

[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]

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.