Use ticket_history table for your query. On Thu, Feb 6, 2014 at 6:29 AM, Darshak Modi 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