Using Expression Operators in a Search
When using expression operators in a search, you can enter part or all of an Attribute name followed by the operator you want to use, and then the value.
Syntax:
<attribute name><operator><value>
An example is:
objectstatus='os'
Where:
objectstatus Is the attribute name
= Is the operator
os Is the value
Note that one or multiple expression operators can be used in a single search sentence.
List of Expression Operators
| [ ] | What is encapsulated in (square brackets) is a common name of a column |
| = | Equal to |
| < | Less than |
| > | Greater than |
| >= or => | Greater than or Equal to |
| <= or =< | Less than or Equal to |
| <> | Greater than or Less than |
EXAMPLE: Search for all "tank" elements with an Object Status of 'os'
Let's say we wanted to search for all Elements having "tank" in their name as well as all Elements of the "tank" "type" in which those Elements have an Object Status of "Out-of-Service" (OS).
The search sentence would be:
tank objectstatus='os'
The search engine would:
Look for all elements, templates and categories matching "tank", having the attribute Object Status equal to OS
The results would be:
All elements matching "tank" that have the attribute Object Status equal to OS
Using [ ] (square brackets) In an Expression
Literals that are encapsulated in [ ] (square brackets) are used to search inside attributes with a data type of table.
Syntax:
[column name]<operator><value>
EXAMPLE: Using [ ] (square brackets) In an Expression
[material] = 'Crude'
Where:
material Is the column name of the data table
= Is the operator
'Crude' Is the value (string values must be enclosed in single quotes)
Using the . (dot) Character In an Expression
When starting the attribute name using the "." (dot) in an expression, you instruct the search engine to look for the content of a complex attribute value type such as "DataTable".
Syntax:
.<column or attribute name><operator>'<value>'
EXAMPLE: Using the "." (dot) Character In An Expression
.material = 'Crude'
Where:
.material Is the column or attribute name of the data table
= Is the operator
'Crude' Is the value (string values must be enclosed in single quotes)