We are in the process of cleaning up our otrs database what I would like to do is find all tickets that are (say) Older then 1 year state == new |\ state == open and bulk-action close them. Is there an easy way to do this ? I guess I can generate a search query export the csv file and then extract the ticket numbers out of that then use a mysql query 9which one ?) to close all tickets that match the numbers generated but I have the feeling there must be an easier way. unfortunetely, the result of a search query miss the [ ] select this ticket for bulk action tick box. Im using otrs 2.2.5 Kind regards, Fugro-Jason Netherlands BV Gerhard den Hollander Senior ICT Engineer Telephone: +31 (0)70 3170 539 / Fax: +31 (0)70 3170 511 E-mail: gdenhollander@fugro-jason.com / Website: www.fugro-jason.com http://www.fugro-jason.com/ Address: Veurse Achterweg 10, 2264 SG Leidschendam, The Netherlands / P.O. Box 35, 2260 AA Leidschendam, The Netherlands Trade Register Nr: 24294747 / VAT: NL 00807174798 B01
Hi, On Mi, Apr 23 2008, Gerhard den Hollander wrote:
what I would like to do is find all tickets that are (say) Older then 1 year state == new |\ state == open
and bulk-action close them.
Is there an easy way to do this?
Yes, create a Genericagent job (Admin -> Genericagent) for that task. Henning -- Henning Oschwald ((otrs)) :: OTRS AG :: Norsk-Data-Straße 1 :: 61352 Bad Homburg 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 Vorstandsvorsitzender: André Mindermann
participants (2)
-
Gerhard den Hollander -
Henning Oschwald