Hi ,
I am new to apex and tryin to filter data for one of the chart using two datepicker. START_DATE and END_DATE.
select SUB_COMPONENT,(case when SUB_COMPONENT = 'GENERIC' then 'red'
when SUB_COMPONENT = 'REACTIVE' then ‘red’
when SUB_COMPONENT = 'PROACTIVE' then 'green'
when SUB_COMPONENT = 'IMP1' then 'yellow'
when SUB_COMPONENT = 'FMSAS' then ‘blue’
when SUB_COMPONENT = 'RESIZE' then 'red'
when SUB_COMPONENT = 'FSCAN' then 'red'
when SUB_COMPONENT = 'ADF' then 'red' end) as the_color ,count(*) from INSERT_DATA_INBOUND
where source_type='inbound'
and to_date(updated_date,'YYYY-MM-DD') >= :START_DATE and to_date(updated_date,'YYYY-MM-DD') <= :END_DATE
group by SUB_COMPONENT order by 2 desc
snippet from page inspect "<input id="START_DATE_input" name="START_DATE" aria-labelledby="START_DATE_LABEL" class="apex-item-text apex-item-datepicker" autocomplete="off" type="date" value="2025-01-22" size="30">