Hello,
I guess you can do like this in the SQL-box: select * from ticket where user_id='4' and (ticket_state_id='1' or ticket_state_id=3 or ticket_state_id='10')
In order to find the user_id, do this: select * from users
The status for the ticket should be like that. You can list the statuses that exist by: select * from ticket_state
If you want to change what states to list, just add or deletet "or ticket_state_id='xxx'" inside the parantheses.
Note that you sould NOT use ';' at the end of the string when using the SQL-box.
I noticed that if you create a ticket with one user, the user_id is set to the user creating the ticket. If you reassign the ticket to some other group, an user in that group opens the ticket and then closes it, the user_id is changed to the user that closed the ticket.
Regards,
Niklas
Den 2010-09-20 12.00, skrev "Marco Vannini"
Hi,
is there any possibility to find all tickets closed (or edited) by a specified agent on a specified date? I didn't find anything in documentation or mailing list history ...
Thx for your suggestions
- Timo
--------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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