[otrs] Generic Agents

[Dave Wojciechowski]

I understand the SQL that your doing here, the part that I'm foggy about is how to get this to run as a generic agent job. 

-----Original Message-----
From: Zhang Wayne [mailto:waynezhang72 at hotmail.com]
Sent: Thursday, March 01, 2007 10:39 PM
To: Dave Wojciechowski
Subject: RE: [otrs] Generic Agents

Step1: Get agent id that need watch ticket not closed over one days select id from system_user where login = :@Agent_Name

Step2: Clean the watch list under monitor list delete from ticket_watcher where user_id = :@system_user.id

Step3: Insert ticket id that need watch under monitor list insert into ticket_watcher select ticket.id, :@system_user.id , sysdate(), 1, sysdate(), 1
  from ticket, ticket_state
 where ticket.ticket_state_id = ticket_state.id
   and ticket_state.type_id <> 3 
   and ticket_state.type_id <> 7
   and ticket.create_time <= date_format(adddate(sysdate(),INTERVAL -1 DAY),'%Y-%m-%d 00:00:00')

@Agent_Name and @system_user.id are parameters that need replace it, coul dyou understand it?


>From: "Dave Wojciechowski" <david.wojciechowski at morgansfoods.com>
>Reply-To: "User questions and discussions about OTRS.org" 
><otrs at otrs.org>
>To: "User questions and discussions about OTRS.org" <otrs at otrs.org>
>Subject: [otrs] Generic Agents
>Date: Tue, 27 Feb 2007 20:19:12 -0500
>
>Hopfully somone has done this before and can help me w/ this, i'm 
>looking for a way to make all ticket that remain open for more than one 
>day be automatically subscribed to for a agent to watch in watch 
>tickets.  Anyone done that b4.


>_______________________________________________
>OTRS mailing list: otrs - Webpage: http://otrs.org/
>Archive: http://lists.otrs.org/pipermail/otrs
>To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
>Support orr consulting for your OTRS system?
>=> http://www.otrs.com/

_________________________________________________________________
免费下载 MSN Explorer:   http://explorer.msn.com/lccn