Hello,
Is it possible to aggregate the values of the note-based dynamic text fields into ticket-based dynamic field? I would like a behavior like in the time accounting: in the ticket information area, there is a time sum of the notes.
Dynamic field aggregation
Moderator: crythias
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Dynamic field aggregation
Possible? Sure, anything's possible.
The question is where do you want the aggregation to be implemented? (As in, display on *THIS* page? Sum in Stats? Available in export?)
If I were to do it in display, I'd modify Kernel/Modules/ModuleThatReflectsTheOneIWantToShow.pm and sum within there.
If I were to do it somewhat globally, I'd create a sum module and extend Ticket.pm
If I just needed the information, I might export and sum in a spreadsheet or run a query against the field.
So, "Is it possible?" No, not out of the box. Anything you want to do with this field needs to be specified and determined for you.
The question is where do you want the aggregation to be implemented? (As in, display on *THIS* page? Sum in Stats? Available in export?)
If I were to do it in display, I'd modify Kernel/Modules/ModuleThatReflectsTheOneIWantToShow.pm and sum within there.
If I were to do it somewhat globally, I'd create a sum module and extend Ticket.pm
If I just needed the information, I might export and sum in a spreadsheet or run a query against the field.
So, "Is it possible?" No, not out of the box. Anything you want to do with this field needs to be specified and determined for you.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
- Znuny newbie
- Posts: 7
- Joined: 31 Jul 2012, 14:15
- Znuny Version: 3.1.7
- Real Name: Gabor Cser
- Company: Digitop Kft.
Re: Dynamic field aggregation
Thanks for the info. So if I understand it right, I can do it only by modifying the code. And what is about the upgades? Will my modification preserved?
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Dynamic field aggregation
your custom modifications should be placed in the same path in otrs/Custom/Kernel/...
even though they'll survive updates there, they won't be patched if there's problems, so consider that.
even though they'll survive updates there, they won't be patched if there's problems, so consider that.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
- Znuny newbie
- Posts: 7
- Joined: 31 Jul 2012, 14:15
- Znuny Version: 3.1.7
- Real Name: Gabor Cser
- Company: Digitop Kft.
Re: Dynamic field aggregation
Thank you, I will try it.