Skip to main content
Solved

IFS Cloud lobby - Error with variable substitutions (DATES)

  • January 24, 2025
  • 3 replies
  • 67 views

shashikahk
Sidekick (Partner)
Forum|alt.badge.img+4

Hi, 

In designing lobbies in IFS Cloud we could use variable substitutions such as ‘#START_OF_THIS_WEEK#’. 
I encountered an issue when we use these variables in WHERE conditions with - (days). 

e.g. 

 if we have a criteria to take the date before the start of the week, I would think that this would work. 

‘#START_OF_THIS_WEEK#’ -1 

but we ended up here with the following error.

 

but, if we use the database method to retrieve the same value here. it works fine. 

 

Am I doing something wrong with the use of these substitution variables? or is this a bug? 

If we use the variables alone they works fine.  

Best answer by Mohamed Asjath

Hi ​@shashikahk,

A bug was identified when using CSV (Context Substitution Values) for dates in the lobby, specifically in the WHERE clause of the datasource. This issue has now been resolved in the following version of IFS Cloud:

IFS Fixed Version:25.1E.0 - 25R1 EA

 

For more details on CSV for dates and its usage, please refer to the technical document.

https://docs.ifs.com/techdocs/24r2/040_tailoring/250_lobby_configurations/080_navigation/#appendix_b_csv_context_substitution_values_for_dates


Thanks

Asjath

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

3 replies

Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • 22 replies
  • January 24, 2025

Hi ​@shashikahk 

 It may be better for you to use Database Functions for Date Calculations

  • Replace substitution variables in the WHERE clause with database functions to handle date arithmetic.
  • Example:
WHERE transaction_date = TRUNC(SYSDATE, 'IW') - 1

  • This approach ensures compatibility with SQL's built-in date handling.
  • It reduces dependency on application-level variable substitution and leverages the database's inherent date handling capabilities.

 


Mohamed Asjath
Do Gooder (Employee)
Forum|alt.badge.img+4
  • Do Gooder (Employee)
  • 16 replies
  • Answer
  • February 14, 2025

Hi ​@shashikahk,

A bug was identified when using CSV (Context Substitution Values) for dates in the lobby, specifically in the WHERE clause of the datasource. This issue has now been resolved in the following version of IFS Cloud:

IFS Fixed Version:25.1E.0 - 25R1 EA

 

For more details on CSV for dates and its usage, please refer to the technical document.

https://docs.ifs.com/techdocs/24r2/040_tailoring/250_lobby_configurations/080_navigation/#appendix_b_csv_context_substitution_values_for_dates


Thanks

Asjath


shashikahk
Sidekick (Partner)
Forum|alt.badge.img+4
  • Author
  • Sidekick (Partner)
  • 6 replies
  • February 15, 2025
Mohamed Asjath wrote:

Hi ​@shashikahk,

A bug was identified when using CSV (Context Substitution Values) for dates in the lobby, specifically in the WHERE clause of the datasource. This issue has now been resolved in the following version of IFS Cloud:

IFS Fixed Version:25.1E.0 - 25R1 EA

 

For more details on CSV for dates and its usage, please refer to the technical document.

https://docs.ifs.com/techdocs/24r2/040_tailoring/250_lobby_configurations/080_navigation/#appendix_b_csv_context_substitution_values_for_dates


Thanks

Asjath

Thank you for the info :) 

Regards,

Shashika


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