Implementing Dynamic Time Filters in IFS Lobby - Datasource Designer

Hi all,

I’m looking to add dynamic time filters to a custom IFS lobby view. I already have a custom date filter implemented, but I’d also like to include:

• Year-to-Date (YTD)

• Last Year vs This Year (LY vs TY)

• Month-to-Date (MTD)

• Rolling 12 months (R12M)

Here’s my current filter logic:

(

(NVL('$TIME_FILTER$', 'YTD') = 'YTD' AND planned_delivery_date BETWEEN TRUNC(SYSDATE, 'YYYY') AND SYSDATE)

OR (NVL('$TIME_FILTER$', 'YTD') = 'LY' AND planned_delivery_date BETWEEN ADD_MONTHS(TRUNC(SYSDATE, 'YYYY'), -12) AND ADD_MONTHS(TRUNC(SYSDATE, 'YYYY'), -1))

OR (NVL('$TIME_FILTER$', 'YTD') = 'MTD' AND planned_delivery_date BETWEEN TRUNC(SYSDATE, 'MM') AND SYSDATE)

OR (NVL('$TIME_FILTER$', 'YTD') = 'R12' AND planned_delivery_date BETWEEN ADD_MONTHS(SYSDATE, -12) AND SYSDATE)

OR (NVL('$TIME_FILTER$', 'YTD') = 'CUSTOM' AND planned_delivery_date BETWEEN

NVL(TO_DATE('$START_DATE$', 'YYYY-MM-DD'), TRUNC(SYSDATE, 'YYYY'))

AND NVL(TO_DATE('$END_DATE$', 'YYYY-MM-DD'), SYSDATE))

)

Has anyone implemented something similar? Any advice or improvements to this approach?

Perhaps an alternative element would be better for displaying this information to users?

Thanks in advance,

Anthony Welsh

!-->