Filtering
Here, you can provide expressions to filter the data. Only data that matches the filter condition is included.
Expression | You can filter for a single data field, or select <Expression...> to open the Expression Editor and enter a customized expression. | |||
Operation |
If you select Contains, you can either filter for exact matches or use wildcards in the Value field. Without wildcards, Contains looks for exact matches. For example, filtering for SAMPLE_NAME Contains 'Sample*' may return 'Sample', 'Sample_1' and 'Sample_2'. Without the wildcard (SAMPLE_NAME Contains 'Sample'), only the exact match 'Sample' would be returned. With the Equals (=) operators you always filter for exact matches. | |||
Value |
You can select a single data field, or select <Expression...> to open the Expression Editor and enter a customized expression.
|
Multiple expressions
If you use multiple expressions in a filter condition, the expressions are linked by And or Or. The way the expressions are linked is set automatically according to the following rules:
If an expression is based on a different data field than the preceding expression, it is linked by And.
If an expression is based on the same data field as the preceding expression, but uses a different operator, it is linked by And.
-
If an expression is based on the same data field as the preceding expression, and it uses the same operator, the link type depends on the operator:
-
Same data field plus Equals (=) operator: Expression is linked by Or.
Same data field plus operator different than Equals: Expression is linked by And.
-
If you need any other combination of expressions, create a single customized expression and check if it returns True or False. For example:
|
Expression |
Operation |
Value |
|---|---|---|
=(Sample_Type=1) Or (Sample_Type>5) |
= |
=True |
| Move the selected expression upwards. |
|
Move the selected expression downwards. |
|
Remove the selected expression. |
