Value ranges in condition and filter expressions
- Last Updated: December 28, 2020
- 2 minute read
- Corticon
- Version 7.2
- Documentation
You can use value range expressions in conditions or filters.
Syntax of value ranges in conditions and filter rows
When you use the in operator to specify
a range of values, you can specify the range in a several ways. The following
illustration shows how you can encapsulate a range:
where:
- Filter 8 does no encapsulation.
- Filter 9 uses braces for encapsulation. Its delimiter in the expression is a comma, rather than two dots like the others. Because this syntax defines a set and overloads the syntax for a list, it is a good practice to not use it to encapsulate a range.
- Filters 10 through 13 use (and mix) parentheses and brackets where a bracket on either side expresses that the value on that side also passes the test.
Examples of value ranges in filter rows
The following value ranges show how the Corticon data types can be used as Filter expressions.