Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date Filter

Brad ChrissApr 7 2025 — edited Apr 7 2025

The code below uses page items to set filters on an IG. I can get the regular text string to add the filter, however I can't get the date filter to add. It adds a blank filter. Is there something I need to do to the date to create the date filter

var grid = apex.region("dd2663");
var filterSite = apex.item("P8_SITE_ID").getValue();
var filterStartDate = apex.item("P8_START_DATE").getValue();
var filterEndDate = apex.item("P8_END_DATE").getValue();
var filters = grid.call("getFilters");
if (filters.length >= 1) {
   for (var i in filters) {
       grid.call("deleteFilter", filters[i].id);
   }
}
if (filterSite && filterStartDate) {
   console.log("Filter on Site and Start Date");
   grid.widget().interactiveGrid("addFilter",{
       type: 'column',
       columnType: 'column',
       columnName: 'A450_SITE_ID',
       value: filterSite,
       operator: 'EQ',
       isCaseSensitive: false
   });
   console.log(filterStartDate);
   grid.widget().interactiveGrid("addFilter",{
       type: 'column',
       columnType: 'column',
       columnName: 'A450_BUS_DATE',
       value: filterStartDate,
       operator: 'GREATER_THAN_EQUAL',
       isCaseSensitive: false
   });
   grid.refresh();
} else if (filterSite) {
   console.log("Filter on Site");
   grid.widget().interactiveGrid("addFilter",{
       type: 'column',
       columnType: 'column',
       columnName: 'A450_SITE_ID',
       value: filterSite,
       operator: 'EQ',
       isCaseSensitive: false
   });
   grid.refresh();
}
This post has been answered by Karel Ekema on Apr 8 2025
Jump to Answer
Comments
Post Details
Added on Apr 7 2025
7 comments
358 views