trough search tool , I can not automate. so
need some query.
Yes I am trying , will post the query and result.
On 2/27/2014 2:47 PM, Gerald Young
wrote:
Something like:
SELECT th.name,
Something like:
SELECT th.name, th.ticket_id, max(th.create_time) FROM `ticket_history` th
left join ticket_history_type tht on th.history_type_id = tht.id where
tht.name = "StateUpdate" and (th.name like "%\%\%new\%\%" OR th.name like
"%\%\%pending %\%\%") group by th.ticket_id
beyond that, you'
why not using search tool inside otrs (
http://otrs/otrs/index.pl?Action=AgentTicketSearch)
then, if you make an export to csv you can do what you want.
2014-02-27 8:23 GMT+01:00 Darshak Modi :
> Hi All,
>
> I can see multiple ticket state in the table. I want to find last state,
> for some tic
