Rules for filtering string values
- Last UpdatedOct 25, 2024
- 2 minute read
These rules describe the filtering syntax that is recognized when you use the Filter Records dialog box to filter field data results in AVEVA Production Management. For more information on how to filter string data types, see Use exact filtering on fields with string data type.
AVEVA Production Management supports filtering syntax, in addition to Date filters.
Guidelines for string values
-
For strings, case-sensitivity is dependent on SQL Server configuration.
-
Only the fields that are filterable appear in the Filter Records dialog box.
Note When selected, string values appear inside double quotation marks, such as "Not Scheduled". These quotation marks are important, as they preserve any spaces included in the string value.
Operators and characters
AVEVA Production Management filtering supports these operators and characters.
|
Operator or Keyword |
Description |
|---|---|
|
( |
opening parenthesis |
|
) |
closing parenthesis |
|
= |
equals |
|
< |
less than |
|
> |
greater than |
|
<= |
less than or equals to |
|
>= |
greater than or equals to |
|
1-9 |
integers |
|
' |
single quotation |
|
" |
double quotation |
Keywords
AVEVA Production Management filtering supports these keywords.
|
Operator or Keyword |
Description |
|---|---|
|
TRUE |
true |
|
FALSE |
false |
|
NOTHING |
value is null |
|
AND |
and |
|
OR |
or |
|
NOT |
not including |
|
WITH RECURSE |
including sub-directory values |
|
CURRENT |
current |
|
LAST |
most recent |
|
BEGINNING |
starting date and time |
|
NOW |
the current date and time |
Examples of filtering syntax with operators and keywords
Some examples of how to write expressions with operators and keywords for filtering:
-
[Value]
-
[Value1] or [Value2]
-
> [Value]
-
>= [Value]
-
< [Value]
-
<= [Value]
-
(> [Value1] and <= [Value2]) or (>= [Value3] and < [Value4])
-
NOT [Value]
-
NOT [Value1] and NOT [Value2]
Wildcards
These rules apply to the [Value] terms for fields with a string data type.
-
"*" is used as a wildcard for multiple characters. For example, A*C returns ABC and ABBC.
-
"?" is used as a wildcard for a single character only. For example, A?C returns ABC but not ABBC.
For more information on filtering string types, see Use exact filtering on fields with string data type.