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