Sort and Filter
- Last UpdatedJul 23, 2024
- 3 minute read
Sorting the Columns
Sorting feature helps you to easily sort the data elements of different quality. You can sort the Name column in all the Diagnostics nodes. You can sort the Quality/Result column in Device Groups and Messages nodes, Client Quality column in Client Groups node, and Quality column in Structure and Transaction nodes.
-
To sort a column, select on the column header.
Filtering the Columns
Filtering feature helps you to filter the data elements in different ways. You can apply multiple filters at the same time by applying filters in different columns. After applying the filter you can also sort the filtered items.
To filter a column:
-
Enter the filter text in the required column.
For example, to filter the items by name, type the required name of the item in the filter text box of the Name column. It displays the items with the given name. It also supports regular expressions. In the filter box enter the regular expressions like .*, \[.?\], \. and so on.
Example
To apply a filter to the below items, you can use different characters, as explained in the following tables:
-
FillLevel.V
-
FillLevel.PV
-
FillLevel.SP
-
FillLevel.SL
-
bFeeder01_Running
-
bFeeder02_Running
-
bFeeder11_Running
-
bFeeder111_Running
-
fHumidity.PV
-
FHumidity.PV
-
fHumidity.SP
-
fLine_Speed.PV
-
fLine_Speed.SP
-
fTempurature.PV
-
fTemparature.SP
-
Tank.Line_1.Value
-
Tank Line2
-
Tank_Line21
-
TankLine2$
Special Pattern characters
|
Character |
Description |
Example |
|
. |
Any character except line terminators (LF, CR, LS, PS). |
“FillLevel.S.” results the items “FillLevel.SP” and “FillLevel.SL” |
|
\d |
A decimal digit character |
“bFeeder\d\d_Running” results “bFeeder01_Running”, “bFeeder02_Running” and “bFeeder11_Running” |
|
\s |
a whitespace character (same as [[:space:]]). |
See character classes in the below tables |
|
\S |
any character that is not a whitespace character (same as [^[:space:]]). |
See character classes in the below tables |
|
\w |
an alphanumeric or underscore character (same as [_[:alnum:]]). |
See character classes in the below tables |
|
\W |
any character that is not an alphanumeric or underscore character (same as [^_[:alnum:]]). |
See character classes in the below tables |
|
\character |
the character as it is, without interpreting its special meaning within a regex expression. Any character can be escaped except those which form any of the special character sequences above. Needed for: ^ $ \ . * + ? ( ) [ ] { } | |
“TankLine2\$” results “tankLine2$” |
|
[class] |
the target character is part of the class (see character classes below) |
See character classes in the below tables |
|
[^class] |
the target character is not part of the class (see character classes below) |
See character classes in the below tables |
Qualifiers
|
Character |
Description |
Example |
|
* |
Any atom (character/digit) is matched 0 or more times |
|
|
? |
Any atom (character/digit) is optional (matched either 0 times or once). |
|
|
+ |
The preceding atom is matched 1 or more times. |
“bFeeding1+_Running” results “bFeeder11_Running” and “bFeeder111_Running” |
|
{n} |
The preceding atom is matched exactly n times |
“bFeeding1{3}_Running” results “bFeeder111_Running” |
|
{n,} |
The preceding atom is matched n or more times. |
“bFeeding1{2}_Running” results “bFeeder111_Running” |
|
{n,m} |
The preceding atom is matched minimum n times and not more than m times |
“bFeeding1{1, 2}_Running” results “bFeeder11_Running” and “bFeeder111_Running” |
Alternatives
|
Character |
Description |
Example |
|
| |
Separates two alternative filter patterns or sub patterns. |
“*Level*|bFeeder??_Running” results “FillLevel.V”, “FillLevel.PV”, “FillLevel.SP”, “FillLevel.SL”, “bFeeder01_Running”, “bFeeder02_Running” and “bFeeder11_Running” |
Assertions
|
Character |
Description |
Example |
|
^ |
Either it is the beginning of the target sequence or follows a line terminator. |
"^bFeeder01_Running" results "bFeeder01_Running" |
|
$ |
Either it is the end of the target sequence or precedes a line terminator. |
“FillLevel.V$” results “FillLevel.V” |
Character classes
|
Character |
Description |
Example |
|
[:classname:] |
Either it is the beginning of the target sequence or follows a line terminator. |
“[a-z]Feeder01_Running” results “bFeeder01_Running” |
|
[[:alnum:]] |
alpha-numerical character |
“Tank.Line_[[:alnum:]].Value” results “Tank.Line_1.Value” |
|
[[:alpha:]] |
alphabetic character |
“[[:alpha:]]Feeding11_Running” results “bFeeder11_Running” |
|
[[:digit:]] |
decimal digit character |
Tank.Line_[[:digit:]].Value” results “Tank.Line_1.Value” |
|
[[:lower:]] |
lowercase letter |
“[[:lower:]]Humidity.PV” results “fHumidity.PV” |
|
[[:print:]] |
printable character |
- |
|
[[:space:]] |
whitespace character |
“Tank[[:space:]]Line2” results “Tank Line2” |
|
[[:upper:]] |
uppercase letter |
“FillLevel.[[:upper]]L” results “fHumidity.PV” |
|
[[:d:]] |
decimal digit character |
“Tank.Line_[[:d:]].Value” results “Tank.Line_1.Value” |
|
[[:s:]] |
whitespace character |
“Tank[[:space:]]Line2” results “Tank Line2” |
|
[^[:space:]] |
a character class that matches any character except a whitespace |
“Tank[^[:space:]]Line21” results “Tank_Line21” |