If you want to filter date values like this:
Then extend the code to your date columns (inside the region source) like this:
My date column name is: IMPORT_DATE
select
...
decode(IMPORT_DATE,null,null,'<!-- ' || to_char ( IMPORT_DATE, 'yyyymmdd' ) || ' -->' || IMPORT_DATE) as IMPORT_DATE
from
...
For more information take a look into this forum thread:
https://forums.oracle.com/forums/thread.jspa?threadID=2346579&start=15&tstart=0
Then extend the code to your date columns (inside the region source) like this:
My date column name is: IMPORT_DATE
select
...
decode(IMPORT_DATE,null,null,'<!-- ' || to_char ( IMPORT_DATE, 'yyyymmdd' ) || ' -->' || IMPORT_DATE) as IMPORT_DATE
from
...
For more information take a look into this forum thread:
https://forums.oracle.com/forums/thread.jspa?threadID=2346579&start=15&tstart=0
2 Comments " APEX IR - Date Filter usage like String columns "
Replace '<!--' with '<', and '-->' with '>', and that works as you intended.
Make sure the display-as for the column is 'Remove HTML and escape special characters'.
Regards,
Markus H.
Have a nice time in your vacation. :-)
Post a Comment