Filter groups in aging request report
I need a way to filter multiple departments in an aging request report. For example, I would like to see all the the aging requests in Support and Billing. Here is my query so far:
SELECT "Department", "<30 Days", ">30 Days", ">60 Days", ">90 Days", ">120 Days" FROM (SELECT wof.UDF_CHAR6 AS "Department",
COUNT(CASE WHEN
DATE_PART('day',now()::timestamp - FROM_UNIXTIME(WORKORDER.CREATEDTIME/1000)::timestamp) < 30 THEN 1 ELSE NULL END) "<30 Days", COUNT(CASE WHEN DATE_PART('day',now()::timestamp - FROM_UNIXTIME(WORKORDER.CREATEDTIME/1000)::timestamp) >= 30 and DATE_PART('day',now()::timestamp - FROM_UNIXTIME(WORKORDER.CREATEDTIME/1000)::timestamp) < 60 THEN 1 ELSE NULL END) ">30 Days", COUNT(CASE WHEN DATE_PART('day',now()::timestamp - FROM_UNIXTIME(WORKORDER.CREATEDTIME/1000)::timestamp) >= 60 and DATE_PART('day',now()::timestamp - FROM_UNIXTIME(WORKORDER.CREATEDTIME/1000)::timestamp) < 90 THEN 1 ELSE NULL END) ">60 Days", COUNT(CASE WHEN DATE_PART('day',now()::timestamp - FROM_UNIXTIME(WORKORDER.CREATEDTIME/1000)::timestamp) >= 90 and DATE_PART('day',now()::timestamp - FROM_UNIXTIME(WORKORDER.CREATEDTIME/1000)::timestamp) < 120 THEN 1 ELSE NULL END) ">90 Days", COUNT(CASE when DATE_PART('day',now()::timestamp - FROM_UNIXTIME(WORKORDER.CREATEDTIME/1000)::timestamp) >= 120 THEN 1 ELSE NULL END) ">120 Days" FROM WORKORDER
INNER JOIN WORKORDERSTATES on WORKORDERSTATES.WORKORDERID = WORKORDER.WORKORDERID
LEFT JOIN STATUSDEFINITION on STATUSDEFINITION.STATUSID = WORKORDERSTATES.STATUSID
LEFT JOIN WorkOrder_Queue woq ON WORKORDER.WORKORDERID=woq.WORKORDERID
LEFT JOIN WorkOrder_Fields wof ON WORKORDER.WORKORDERID=wof.WORKORDERID
LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID
WHERE StatusDefinition.ISPENDING='1'
GROUP BY wof.UDF_CHAR6
ORDER BY 1
) A WHERE "<30 Days" + ">30 Days" + ">60 Days" + ">90 Days" + ">120 Days" > 0 limit 50000