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" <marco.vannini@gmail.com>:
Try using search function (lens icons) there should be everything you
need for this purpose
On Mon, Sep 20, 2010 at 11:48 AM, Rupp Timo <Rupp@huberverlag.de> wrote:
> 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