Event tag for work unit

Moderator: crythias

Locked
pcraponi
Znuny newbie
Posts: 6
Joined: 25 Jul 2011, 14:01
Znuny Version: 5.0.10
Real Name: Paulo Raponi
Company: LDC

Event tag for work unit

Post by pcraponi »

Hi All,

Have some <OTRS_Ticket_XXXX> to get the work unit on close ticket?

I need this field -> http://imageshack.us/photo/my-images/801/workunits.jpg/ to put on a email when TicketStateUpdate event trigger.

How I can do this?



regards,

Paulo Raponi
OTRS 3.0
Lorenzo_Marschall
Znuny advanced
Posts: 106
Joined: 13 May 2011, 14:47
Znuny Version: 2.4 / 3.x
Real Name: Lorenzo Marschall
Company: bmsoft information technologies GmbH
Location: Germany, Italy
Contact:

Re: Event tag for work unit

Post by Lorenzo_Marschall »

Why can't you find the workunits in the OTRS_Ticket_* variable?

1. workunits are based on articles, they don't rely on the ticket itself
2. workunits are saved in the table time_accounting with relation to table article

A list with OTRS_* variables:

http://faq.otrs.org/otrs/public.pl?Acti ... ItemID=186

Well, this could be a very dirty workaround:

1. trigger event on ticket close
2. execute shell script: export defined stat job
2.1 parse stat export, where you can find aggregated workunits
2.2 generate an email using this data
3. done

The stats module collects these data through a SQL statement, so it is obvious they are not available in a variable directly.

HTH.
OTRS + ITSM + PostgreSQL @ Debian
Locked