I'd like to specify custom column filters for a date column in an interactive grid using LOVs.
I can't find any documentation on how to specify the LOV Display and Return values, or how they interact with the values in the column for a DATE column.
An AI generated the solution below, but it is not working. Even putting in static values like “11/07/2023” does nothing when selected.
So, can anyone explain how to specify date ranges below in a custom column filter LOV? Or some other way?
This is configured as a simple shared component LOV:
Oracle docs are not helpful for specifying format of LOV:
Links to documentation on how to provide these would be great, as the Oracle docs appear to be missing any examples or details beyond “Provide an LOV”.