OQL RANGEBEGIN
1 Description
The RANGEBEGIN
function extracts the initial 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 RANGEBEGIN
function in the WHERE
clause, which will give you all the customers born since the beginning 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.