Skip to Content
0
Nov 03, 2019 at 06:16 AM

Filter by Date using the object command

66 Views

SELECT DECODE(c.description, '', 'Total', c.description) "Support Data", count(b.case_cd) "Count"

FROM

a,b,r

WHERE

a.case_id = b.case_cd AND

b.outcome_support_data_cd = c.outcome_support_data_id and

a.closure_date >= to_date('{?closure_start_date}','MM/DD/YYYY') AND

-------> this line above and the one below if comment errors disappers

a.closure_date <= to_date('{?closure_end_date}','MM/DD/YYYY')

AND a.deleted_ind = 0 AND

a.region_assigned = r.region_id AND

UPPER(r.description) LIKE UPPER('{?description}'||'%')

GROUP BY DECODE(c.description, '', 'Total', c.description)

ORDER BY 1