You may query the database directly or write a custom script which does
something like the following:
SELECT id, tn, title, customer_user_id FROM ticket
WHERE (( ticket_state_id = 2 OR ticket_state_id = 3)
AND (change_time LIKE "2005-08-29%" AND user_id = 6));
This shows all successfully and unsuccessfully closed tickets for
2005-08-29 and the user with the id 6 found in system_user.
With the id you can build links to the tickets.
If you just want to see the number of closed tickets, use the COUNT()
function.
Hope that helps.
Best regards,
Sascha Rommelfangen
"Sheline, Carl (LLU)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
29/08/2005 19:54
Please respond to
"User questions and discussions about OTRS.org" <otrs@otrs.org>
To
"User questions and discussions about OTRS.org" <otrs@otrs.org>
cc
Subject
[otrs] Searching by close date
I would to search for all the closed successful tickets for a specific
technician by date closed. In 1.3.2 the only option is search by ticket
create date which is not quite the same thing.
What are my options?
Thanks for your help.
Carl Sheline
[EMAIL PROTECTED]
_______________________________________________
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/
_______________________________________________
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/
