Using a Context Substitution Value (CSV) date variable with arithmetic in a Lobby datasource's WHERE clause (like `'#START_OF_THIS_WEEK#' -1`) throws an error, even though the same variable used alone works fine.

All FAQ questions / Platform, Aurena, and customization

Answer

This has been confirmed as a genuine bug specifically affecting date-arithmetic expressions built on Context Substitution Values inside a Lobby datasource's WHERE clause — check whether your current release already includes the fix (addressed starting around the 25R1 early-access track) before spending more time adjusting the expression syntax itself, since the same value used without arithmetic, or the equivalent computed via a database function call, works around the underlying issue in the meantime.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Platform, Aurena, and customization questions