Skip to Main Content
Feature Request FR-2552
Product Area Page Components
Status CLOSED

15 Voters

Allow customization of filters for date column in Interactive Report

rowan.ainsworth Internal · Jun 2 2022

Idea Summary
Allow customization of the set of filters that are shown for a date column in an Interactive Report on click of the column heading.

Use Case
We are using an Interactive Report to display telemetry data, which will date back no more than a month. There are three filters beyond "Last Month" in the predefined set and we don't want to misrepresent the amount of history available.

We reviewed this idea carefully, and while it was interesting, we concluded that it is unlikely to make its way into APEX in the foreseeable future.

Comments

Comments

  • jayson hanes Admin OP 3.1 years ago

    Interesting.. I've never thought about this, but I can appreciate the issue that you describe. It really isn't easy to remove these from a developer point of view because the HTML is built dynamically each time it's invoked by clicking the header.

  • mark stewart OP 3.1 years ago

    One possibility would be to specify at design time, to use the current Date filter, and another option that would present a drop-down for conditions like “less than”, “greater than”, etc. and a Pop-up Calendar to choose a date as the value for the condition.

  • shelly.simpson OP 2.9 years ago

    Another use case; we often need to look at data based on our fiscal quarters.  It would be great to define filters on the column header that are based on that (or any custom “chunks” of dates):

    • FY2022 Q1
    • FY2022 Q2
    • FY2022 Q3
    • etc.
  • scott.chaplow OP 1 years ago

    In APEX 5.1.4 we were able to use the IR field's “Column Filter” override to present a list of actual dates ("Use Defined List of Values to Filter Exact Match"). In our case the dates were always the first day of the month, so we wanted the actual available dates shown. This feature no longer works for dates in APEX 23.2 or 24.1 (does still work for character fields) - SR 3-37123165731