Use ticket_history table for your query.


On Thu, Feb 6, 2014 at 6:29 AM, Darshak Modi <darshak.modi@elitecore.com> wrote:
hi,
we want find how many tickets created in a day [ new ], how many are worked upon [ closed ] and if any tickets remain opened.
I am generating using report tool. But all tickets that are closed , come only in closed state, and not in new state.

it is difficult to know how many actually created , closed and carried forward if any .
I get report like below
State Type Thu 30 Fri 31
closed 14 16
new 1 0
open 0 0
Sum 15 16


Here it should come like new is 15, closed 14, open 1. Is that possible ?

---------------------------------------------------------------------
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