Hi all,
I’m trying to configure a pie chart in IFS that groups Purchase Order Lines by Planned Receipt Date using a calculated column called Days, which bins records into segments like ‘Overdue’, ‘Next 7 Days’, ‘Next 14 Days’, etc.

Here’s the CASE logic used for the Days column:
(CASE WHEN PLANNED_RECEIPT_DATE < TRUNC(SYSDATE) THEN 'Overdue' WHEN PLANNED_RECEIPT_DATE BETWEEN TRUNC(SYSDATE) AND TRUNC(SYSDATE + 6) THEN 'Next 7 Days' WHEN PLANNED_RECEIPT_DATE BETWEEN TRUNC(SYSDATE + 7) AND TRUNC(SYSDATE + 13) THEN 'Next 14 Days' WHEN PLANNED_RECEIPT_DATE BETWEEN TRUNC(SYSDATE + 14 ) AND TRUNC(SYSDATE + 20) THEN 'Next 21 Days' WHEN PLANNED_RECEIPT_DATE BETWEEN TRUNC(SYSDATE + 21) AND TRUNC(SYSDATE + 29) THEN 'Next 30 Days' WHEN PLANNED_RECEIPT_DATE >= TRUNC(SYSDATE + 30) THEN '30+ Days' END)
I’ve grouped the pie chart on this Days column and want each segment (e.g. “Overdue”) to link to the Purchase Order Lines page, filtered by the corresponding date range.
My current NAV URL filter logic is:
page/PurchaseOrderLines/List?$filter=(Days eq PlannedReceiptDate lt)
My question:
How can I dynamically filter the NAV URL based on which pie chart segment is clicked — for example, when “Overdue” is clicked, only show rows where PLANNED_RECEIPT_DATE < TRUNC(SYSDATE)?
Has anyone implemented this kind of conditional date filtering through NAV URLs based on CASE segments before?
Any help or pointers much appreciated!