Adding field for miles travelled

Moderator: crythias

Locked
ruttchen
Znuny newbie
Posts: 11
Joined: 08 Dec 2010, 17:31
Znuny Version: 3.0.10

Adding field for miles travelled

Post by ruttchen »

Hi,

We have some external agents.
When they visit a customer site, we sometimes charge a call-out fee, based on the zone (km traveled).
We'd like to register the Km with the ticket, just like the 'time units' are used when adding a note.
In the ticket overview, or on the reports, you can see the total time units.

When using a TicketFreeText, we can select this in a note, and see it in the overview or on a report.
But when a agent travels multiple times to that (or a different) site, the old value is replaced.

When we use a ArticleFreeText, the value is added in the notes, but we cannot get it to appear on the overview or reports.

Is this something someone has already done, or do we need to script a query to the database, the get the sum of the ArticleFreeText?
And is it possible to add this value to stats, so we can get a report with closed tickets, total time and total km?

Thanks in advance,
ruttchen
Znuny newbie
Posts: 11
Joined: 08 Dec 2010, 17:31
Znuny Version: 3.0.10

Re: Adding field for miles travelled

Post by ruttchen »

Still haven't found a solution for this. Does anyone have an idea how to solve this? Or is this not possible yet?
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Adding field for miles travelled

Post by crythias »

You can get Article information when you use a report based upon Ticket History.
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
ruttchen
Znuny newbie
Posts: 11
Joined: 08 Dec 2010, 17:31
Znuny Version: 3.0.10

Re: Adding field for miles travelled

Post by ruttchen »

Hello crythias,

Thank you very much, that helped alot.
Locked