I currently have a badge list pluggin, with following code given below. I would like to change this to cards . The issue here is with the link on the card. In The last two sections of the Union in the query , the link is to a different page. In badge list I could define the Link URL in the Query itself. How can I do the same in the. Cards. Meaning define the URL in the query itself
I am on Apex 21.2 The lastest version available now .
can someone help me with this .
Thanks a lot
select
'New' as label,
trim(to_char(nvl(count(a.incident_no),0),'999G999G999G999G990')) as value,'f?p='||:APP_ID||':39:'||:APP_SESSION||'::NO:39:P39_STATUS:New' as url
from socmis_incidents a
where status in('New')
union all
select
'Assigned' as label,
trim(to_char(nvl(count(a.incident_no),0),'999G999G999G999G990')) as value,'f?p='||:APP_ID||':39:'||:APP_SESSION||'::NO:39:P39_STATUS:Assigned' as url
from socmis_incidents a
where status in('Assigned')
union all
select
'Resolved' as label,
trim(to_char(nvl(count(a.incident_no),0),'999G999G999G999G990')) as value,'f?p='||:APP_ID||':39:'||:APP_SESSION||'::NO:39:P39_STATUS:Resolved' as url
from socmis_incidents a
where status in('Resolved')
union all
select
'Over Due' as label,
trim(to_char(nvl(count(a.incident_no),0),'999G999G999G999G990')) as value,
'f?p='||:APP_ID||':97:'||:APP_SESSION as url
from socmis_incidents a
where status not in('Closed','Cancelled','Resolved')
AND A.DUE_DATE< CURRENT_TIMESTAMP
union all
select
'closed this month' as label,
trim(to_char(nvl(count(a.incident_no),0),'999G999G999G999G990')) as value,
'f?p='||:APP_ID||':83:'||:APP_SESSION as url
from socmis_incidents a
where status in('Closed')
AND A.CLOSING_DATE BETWEEN
(add_months(last_day(sysdate),-1)+1) AND
last_day(sysdate)