On 04/17/2014 07:30 AM, Gerald Young wrote:
sum(case when t.ticket_lock_id = 1 then 1 else 0 end) as unlocked
select q.name queue, sum(case when t.ticket_lock_id = 1 then 1 else 0 end) as unlocked, sum(case when t.ticket_lock_id = 2 then 1 else 0 end) as locked from ticket t left join queue q on q.id=t.queue_id left join ticket_state ts on ts.id = t.ticket_state_id group by q.name order by q.name;
Worked great, Thanks! -- Stephen Clark *NetWolves Managed Services, LLC.* Director of Technology Phone: 813-579-3200 Fax: 813-882-0209 Email: steve.cl...@netwolves.com http://www.netwolves.com
--------------------------------------------------------------------- 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