
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 csheline@llu.edu

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)"
participants (2)
-
Sascha.Rommelfangen@ses-astra.com
-
Sheline, Carl (LLU)