The select command
- Last UpdatedJan 13, 2023
- 1 minute read
- PI System
- PI Server
You can select entries based on any attribute in the table, but you must always specify a selection rule for the primary key. In the previous example, the primary key is ID so the select statement includes ID=*.
You can use the wildcards * and ? in select statements.
-
* matches all characters
-
? matches a single character
To view the current selection rules, run the command @sele ?.
The selection operators are shown in the following table.
|
Operator |
Meaning |
|
= |
Equals |
|
<> |
Not equal to |
|
> |
Greater than |
|
>= |
Greater than or equal to |
|
< |
Less than |
|
<= |
Less than or equal to |
Note: If you have an attribute with multiple records, if you do not specify the primary key in your select statement and use the ostr command, we repeat on every attribute. If you specify the primary key in the select, we repeat only on the primary key. See Tables where the primary key has multiple records for more information.