Dynamic field aggregation

Moderator: crythias

Locked
gcser
Znuny newbie
Posts: 7
Joined: 31 Jul 2012, 14:15
Znuny Version: 3.1.7
Real Name: Gabor Cser
Company: Digitop Kft.

Dynamic field aggregation

Post by gcser »

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.
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Dynamic field aggregation

Post by crythias »

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

Post by gcser »

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?
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Dynamic field aggregation

Post by crythias »

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

Post by gcser »

Thank you, I will try it.
Locked