Objective: Refresh a region, but not the entire page, where the region has a query based on the value of a page item the user has selected. I (think) I (would) have the region refresh working fine but the page item the query uses is not in Session State!
Current Question: I have a procedure (APEX_UTIL.SET_SESSION_STATE) to place a value the user enters into Session State but how do I get that value in the first place?
What I have in the region:
:P23_SELECT_RUN_DT (date picker)
Rows retrieved based on this date picker. And initially, the query retrieves all rows because :P23_SELECT_RUN_DT (date picker) is null.
I'm trying to follow {message:id=9781139},
I have added a DA (event: change) with the following PL/SQL:
BEGIN
APEX_UTIL.SET_SESSION_STATE('P23_SELECT_RUN_DT','???');
END;
But how do I specify the value to be used is from the date picker? I can’t use :P23_SELECT_RUN_DT; it's null.
I've added this :P23_SELECT_RUN_DT item to an example I'm already working:
WS: APEX_EXAMPLES_01
USER: demo
PW: demo
Application: 991203 - BPR_991203 Page 23 (Tab: Master 3)
Click the edit pencil after "ProgramName 1" to populate all three regions. The date picker is in the third region.
Is this the approach to use? Can someone suggest a more straight-forward way to accomplish this?
Thanks in advance,
Howard