OQL RANGEEND
Last modified: February 13, 2024
1 Description
The RANGEEND
function extracts the end value of a range parameter.
The syntax is as follows:
RANGEEND ( $range )
$range
specifies the range parameter.
2 Example
RANGEBEGIN and RANGEEND
are OQL functions that use a parameter, and OQL parameters are only available in datasets (which are used for generating a report). When you create a page and add a report that has a dataset, you can use RANGEBEGIN
and RANGEEND
in that dataset.
This is an example of using a range in OQL, where $range
is set to last week, which will give you all the customers born in the last week:
|
|
This example uses the RANGEEND
function in the where-clause, which will give you all the customers born since the end of last week:
|
|