Skip to content

Is it possible to filter a Lobby's data source using a date range passed in through two page parameters (a start date and an end date), rather than a single fixed date?

Answer

Yes — in the Lobby Datasource Designer's WHERE condition, reference both parameters directly in a BETWEEN clause (for example, created_date between '$starting_date$' and '$end_date$'), wrapping each in to_date(nvl(...), 'dd/mm/yyyy') with sensible fallback bounds if you want the lobby to still return sensible results when a user leaves one or both parameters blank. For large datasets, add a short-circuit condition that evaluates to true when both parameters are blank (checking nvl('$starting_date$','%') = '%' style conditions) ahead of the actual date comparison, so the query planner doesn't need to evaluate a date range against every row just to determine both parameters were left empty.

← Browse Platform, Aurena, and customization questions