Skip to main content
Question

How can I filter Purchase Order Lines page by Planned Receipt Date from a Pie Chart element using a lobby Nav URL?


awelsh
Do Gooder (Customer)
Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • 4 replies

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!

 

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings