Search Operators
When performing a search it's possible to enter an expression instead of a plain value. The following search operators are available in YaPlm:
Search Operator |
Definition |
*
|
Wildcard. Specifies that any character may follow.
|
_
|
Wildcard. Represents any single character
|
""
|
Quoted strings are used as is, no parsing is performed
|
!{value}
|
Not. - Matches all items where the attribute is not equal to {value}.
|
>{value}
|
Greater than. Matches all items where the attribute is greater than {value}.
|
>={value}
|
Greater than or equal. Matches all items where the attribute is greater than or equal to {value} .
|
<{value}
|
Less than. Matches all items where the attribute is less than {value}.
|
<={value}
|
Less than or equal. Matches all items where the attribute is less than or equal to {value}
|
{lower}^{upper}
|
Range. Matches all items where the attribute is greater than or equal to {lower} and less than or equal to {upper}.
|
{expression 1}|{expression 2}
|
Or. Matches all items that satisfy either <expression 1> or <expression 2>.
|
{expression 1}&{expression 2}
|
And. Matches all items that satisfy both <expression 1> and <expression 2>.
|
null
|
Matches the items where the attribute is null
|
!*_*
|
Searching in on a object where a field is empty
|
Examples
Wildcard
Wildcard character is a character that may be substituted for any of a defined subset of all possible characters.
Pla* will find all objects where the attribute begins with 'Pla'
Pla_ will find all object where the attribute begins with 'Pla' and substitute _ with any single character
Not
Not is used to exclude items from the result.
!null will find objects where the attribute is not null.
!pump* will find all objects that do not begin with pump.
Greater, Lesser than
These operators can be used to limit the result range.
<=10 will find all objects where the attribute begins with 10 or lower
Range
Find items where the attribute is within a range.
1^5 will find objects where the attribute is within the range 1 to 5
Or
Logical operator used to supply multiple expressions, where any of the sub expressions needs to be satisfied.
cat|dog|pig will find objects where the attribute is equal to either cat, dog, or pig.
5|>=10 will find objects where the attribute is equal to 10 or greater than or equal to 5.
And
Logical operator used to supply multiple expressions, where all of the sub expressions must be satisfied.
Only really useful to exclude multiple values from the result.
!cat&!dog&!pig will exclude all objects where the attribute is equal to either cat, dog, or pig.