Skip to main content
Solved

Lobby - navigation current year


Forum|alt.badge.img+6
  • Do Gooder (Customer)
  • 27 replies

How can I set current month or current year when filtering IFS Lobby nagivation? Both below links do not work.

page/PurchaseDeliveryStatistics/List?filter=(REAL_DELIVERY_DATE eq '#THIS_YEAR#')

page/PurchaseDeliveryStatistics/List?filter=(REAL_DELIVERY_DATE eq '#THIS_MONTH#')

Best answer by Alexander Heinze

Here is a list of substitution variables:

I would try

REAL_DELIVERY_DATE eq ‘#YESTERDAY#’ , if that doesn’t work try

(REAL_DELIVERY_DATE ge '#YESTERDAY#') and (REAL_DELIVERY_DATE lt '#TODAY#')

View original
Did this topic help you find an answer to your question?

8 replies

Alexander Heinze
Superhero (Employee)
Forum|alt.badge.img+23

It looks like you're trying to compare a date value with a number value, which doesn't work. So either modify the left operator to give you the month portion of the date (and do the same for the year) or - better - something like

(REAL_DELIVERY_DATE ge '#START_OF_THIS_YEAR#') and (REAL_DELIVERY_DATE le '#END_OF_THIS_YEAR#')

Cannot test this myself at the moment but worth a try. Replace YEAR with MONTH if needed. 


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Customer)
  • 27 replies
  • July 30, 2024

Hi Alexander,

I tried like this, but got an error.

page/SupplierInvoicesAnalysis/List?filter=(REAL_DELIVERY_DATE ge '#START_OF_THIS_YEAR#') and (REAL_DELIVERY_DATE le '#END_OF_THIS_YEAR#')


Alexander Heinze
Superhero (Employee)
Forum|alt.badge.img+23

I just recognized that I only looked at your filter and the substitution variable, so let’s take a step back. What are you trying to achieve? You want to filter records in a list on a transactional page? And should the filter be hardcoded? And from which lobby element are you navigating to the list?

It may be worth looking at https://docs.ifs.com/techdocs/24r1/040_tailoring/250_lobby_configurations/040_element_designer


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Customer)
  • 27 replies
  • July 31, 2024

Hi Alexander,

Actually, your suggestion above works. My bad, I pointed to the wrong page. :)

page/PurchaseDeliveryStatistics/List?filter=(REAL_DELIVERY_DATE ge '#START_OF_THIS_YEAR#') and (REAL_DELIVERY_DATE le '#END_OF_THIS_YEAR#')

If you don’t mind, how can I filter for yesterday date only? Same link navigation page (from Lobby)

page/PurchaseDeliveryStatistics/List?filter=(REAL_DELIVERY_DATE = PREVIOUS DATE ONLY)

 

 


Alexander Heinze
Superhero (Employee)
Forum|alt.badge.img+23
  • Superhero (Employee)
  • 900 replies
  • Answer
  • August 1, 2024

Here is a list of substitution variables:

I would try

REAL_DELIVERY_DATE eq ‘#YESTERDAY#’ , if that doesn’t work try

(REAL_DELIVERY_DATE ge '#YESTERDAY#') and (REAL_DELIVERY_DATE lt '#TODAY#')


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Customer)
  • 27 replies
  • August 1, 2024

Works great. Thank you :)


Forum|alt.badge.img+10
  • Hero (Customer)
  • 120 replies
  • September 14, 2024

@Alexander Heinze is there a page on aurena showing your screen shot please? 


Alexander Heinze
Superhero (Employee)
Forum|alt.badge.img+23

I simply created a SQL-based lobby element with the statement

Select * from context_substitution_var 


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