I have a chart to link to an IR. I am trying to set the link in the query to link to an IR where the column values are null. I'm on Apex 5.1.
This is my query. Can someone correct the link in the query to a column where the values are null please? I've tried using the Link Builder to see how the link would appear so I could copy it, but I'm not able to go that route either.
Thanks,
Khemra
select url, label, Value
from (
SELECT
'f?p='||:APP_ID||':2:'||:APP_SESSION||':::1,RIR:IREQ_CR_MDT_PHYS:ISNULL:' URL,
'Patients Added' label,
sum(case when CR_MDT_PHYS is null then 1 else 0 end) Value
FROM
CR_MDT
where CR_MDT_DT between TO_DATE('01/01/2017', 'mm/dd/yyyy') and TO_DATE
('12/31/2017', 'mm/dd/yyyy')