Skip to Main Content

How do I set null in link to IR

Idkfa2Dec 6 2017 — edited Dec 6 2017

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')

This post has been answered by -W. on Dec 6 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Jan 3 2018
Added on Dec 6 2017
2 comments
330 views