You can't from the search screen. This probably has something to do
with the fact that a ticket can be closed more than once in its
lifetime and closing can be done in multiple ways. You can try using
SQL to get what you want.
Something like the following query might help:
SELECT t.tn, th.name, th.create_time
FROM ticket_history as th left join ticket as t on th.ticket_id=t.id
WHERE th.history_type_id IN (27,30,15)
AND th.name like "%closed%"
ORDER BY th.create_time
This will return ticketnumbers, a brief description of how it was
closed and the corresponding timestamp. You can also define date-time
ranges to search for in MySQL using the Now() and Interval functions,
so a bit more tweaking is possible. You'll have to check for the
correct syntax to use though.
hth,
Edgar Meij
On Tue, 1 Feb 2005 10:06:22 +0100 (MET), Anne-Mie Vandermeeren
Hi,
How do I search for tickets that were closed on a certain day. I can only use the creation date in the search window, not the close date.
Anne-Mie _______________________________________________ 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 oder Consulting für Ihr OTRS System? => http://www.otrs.de/
-- 'An approximate answer to the right question is worth a great deal more than a precise answer to the wrong question'