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: [EMAIL PROTECTED]
/ 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
_______________________________________________
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 or consulting for your OTRS system?
=> http://www.otrs.com/
