The table called ticket.
Hint: read the column/field names and make a somewhat educated guess that
the fields hold ids that match to tables of similar names that hold columns
that have values that represent the thing being sought.
In other words: Read the tables and column names. Get hints from them. Try
to make your own query. If you fail, THEN ask the next question, with the
query you tried to use, what went wrong, etc.
On Fri, Apr 12, 2013 at 2:59 AM, Darshak Modi
Hi, I want ticket details per queue and total. Like, total tickets per queue, open tickets per queue like that.
From which tables can I get that?
-- Darshak Modi | Elitecore Technologies Telecom Practices- India Office: 079-26405600 | +91-9909008245 Skype: darshakamodi
--------------------------------------------------------------------- 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