I want to create a Dashboard, for this purpose initially created an Application Item PATIENT_MR_NO, a Dynamic List like below:
select '1' as level_value,
'OPD' as label,
'f?p=&APP_ID:5:&APP_SESSION.::::' as target,
'YES' as is_current,
'1' as image_value,
null as image_attr_value,
null as image_alt_value,
total_opd attr1
from
(select count(*) total_opd from opd_appointment where mr_no = :PATIENT_MR_NO)
union all
select '1' as level_value,
'Alergy' as label,
'f?p=&APP_ID:5:&APP_SESSION.::::' as target,
'YES' as is_current,
'1' as image_value,
null as image_attr_value,
null as image_alt_value,
total_alergy attr1
from
(select count(*) total_alergy from (select a.pres_id, a.mr_no, pa.alergy_id, al.ALERGY_DESC_E
from opd_pres_master a, opd_pres_alergy pa, alergy al
where a.mr_no = :PATIENT_MR_NO
and pa.pres_id = a.pres_id
and al.alergy_id = pa.alergy_id))
note: removed 1 select statement to avoid big length of this post.
created a page using Dashboard, changed first region type to List, selected my created list from shared component, in Attributes the List Templated is Badge List, created a page item (P4081_MR_NO) of type Select List to select Patient which return MR No, a Dynamic Action which Event is Change, first True action type is Execute Server-side code, PL/SQL Code is: :PATIENT_MR_NO := :P4081_MR_NO; 2nd True action is to refresh the above mentioned Region. Items to submit: P4081_MR_NO, Items to Return: PATIENT_MR_NO
when run and select an MR No it is not refreshing / changing values unless i refresh the page with browser option or F5 key.
what i am doing wrong here or missing? it should refresh and update the values when user select another MR No.
also checked the value of Application Item in Session, it is showing that it sets the value correctly but can't refresh the region.
please help.
regards