APEX

I'm using Apex 24.2 on a 21C database

I have an interactive report that I'd like to refresh when either of two page item dates change. The report works fine when i hard-code the date (that line is commented out).

Select
   ae.event_date
 , APEX_ESCAPE.STRIPHTML(ae.event_name) "Event Name"
 , APEX_ESCAPE.STRIPHTML(ae.review_detail) "Review Detail"
 , APEX_ESCAPE.STRIPHTML(ae.announcement) "Announcement"
 , ac.honorific
 , ac.first_name
 , ac.last_name
 , ac.suffix
From
   aff_event ae
 , aff_contact ac
 , aff_event_presenter aep
Where
   ac.prim_key = aep.contact_fkey
   and
   aep.event_fkey = ae.prim_key
   and
--    ae.event_date > to_date('2023_10_02', 'yyyy_mm_dd')
   ae.event_date
       between to_date(:P206_CUSTOM_START, 'yyyy_mm_dd')
       and     to_date(:P206_CUSTOM_END, 'yyyy_mm_dd')
Order by ae.event_date;

The dates are defined as type=Date Picker, with a Display As = Popup ,with Format Mask = yyyy_mm_dd.

I've created a Dynamic Action: Event Scope = Static, Type = Immediate, Event = Change, Selection Type = Region, Region = Select Dates

The True Action: Action = Refresh, Selection Type = Items, Items = P206_CUSTOM_START,P206_CUSTOM_END, Event = UpdateReportWhenDatesChange, Fire When Event Result Is = True.

There is no option for “Page Items To Submit” I don't understand why that option isn't available to the True action.

In the application, when I select a date, there is absolutely no “flicker” on the screen.

What do I need to change in order for this to work?

Thanks for looking at this.