OQL RANGEEND
1 Description
The RANGEEND
function extracts the end value of a range parameter.
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.
2 Syntax
The syntax is as follows:
|
|
$range
specifies the range parameter.
3 Example
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:
|
|
Feedback
Was this page helpful?
Glad to hear it! Thank you for your response.
Sorry to hear that. Please tell us how we can improve.