GenericAgent time since ticket moved or last action

Hi I am trying to write (command line) a GenericAgent to automatically close tickets that are in a 'complete' folder once they have been in that folder for 1 week. but I cannot find the keyword for TimeSinceLastAction or TimeSinceMoved or something like that the tickets can be over 18 days old and still active in other queues. I can only calculate time from when they were moved into the 'complete' queue. and at this point after 7 days tickets would be locked and unlocked states. does anyone know the keyword I need or even a list of the keywords available, i havnt been able to find a definitive list thanks steven

Hi Stephen, On Aug 19, 2009, at 14:21 , Stephen Gebbie wrote:
I am trying to write (command line) a GenericAgent to automatically close tickets that are in a 'complete' folder once they have been in that folder for 1 week. but I cannot find the keyword for TimeSinceLastAction or TimeSinceMoved or something like that
the tickets can be over 18 days old and still active in other queues. I can only calculate time from when they were moved into the 'complete' queue. and at this point after 7 days tickets would be locked and unlocked states.
does anyone know the keyword I need or even a list of the keywords available, i havnt been able to find a definitive list
This attribute is currently not supported by the generic agent. If you want to get "time since ticket moved or last action" you need to do an database lookup in the ticket_history table. -=> More about this kind of issues on the developer list. ;) -Martin

HI, This can't be done, because there is no event like this. Try the following: 1.) pending 18 days and move 2.) database generic agent(frontend) that checks every day for tickets that have reached their pending date. 3.) then close ticket Alternative, set pending auto close, then you need no generic agent except the pending_jobs included with OTRS. On 19.08.2009, at 14:21, Stephen Gebbie wrote:
Hi I am trying to write (command line) a GenericAgent to automatically close tickets that are in a 'complete' folder once they have been in that folder for 1 week. but I cannot find the keyword for TimeSinceLastAction or TimeSinceMoved or something like that
the tickets can be over 18 days old and still active in other queues. I can only calculate time from when they were moved into the 'complete' queue. and at this point after 7 days tickets would be locked and unlocked states.
-- Shawn Beasley Senior Support Engineer ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Geschäftssitz: Bad Homburg Amtsgericht Bad Homburg, HRB 10751 Steuernummer: 003 240 97505 Aufsichtsratsvorsitzender: Burchard Steinbild Vorstand: André Mindermann (Vorsitzender), Martin Edenhofer NEU! ENTERPRISE SUBSCRIPTION - JETZT informieren und buchen! http://www.otrs.com/de/support/enterprise-subscription/

thanks, that would work as solution. the only issue I have is trying to find the pending time settings. I want to sent the pending autoclose+ to 7 days. then when I run the cron daily, it'll close all the 7 day old tickets. but I cannot find anywhere the settings to configure any times thanks
participants (3)
-
Martin Edenhofer
-
Shawn Beasley
-
Stephen Gebbie