Hello all,
For our customer accouting I'm trying to find all closed tickets in
a certain time frame. I can do that, but when I do that I get
accounting tickets for every ticket closed. Now I'm trying to find
out how I can select only one accounting record for a group that's
closed with a bulk action.
I already have got:
select *
from time_accounting, article, ticket, queue
where
( queue.name like 'CUST::%' or
queue.name = 'CUST'
)
and queue.id=ticket.queue_id
and time_accounting.ticket_id=ticket.id
and time_accounting.article_id=article.id
and date(from_unixtime(article.incoming_time)) between '2010-05-01' and
last_day('2010-05-01');
Does anyone have any idea how to determine which tickets are closed in a group?
Thanks in advance.
Cheers,
TonK
---------------------------------------------------------------------
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
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
