Numeric QBE Operators and Examples
Numeric Operators
The following numeric QBE operators are examples of potential search queries using special characters and combinations of special characters.
|
Characters |
Operators |
Explanation |
Examples |
Queries For |
|---|---|---|---|---|
|
= |
Equals |
Equals the given number. |
=16 |
16 |
|
! |
Not equal |
Not equal to the given number. |
!16 |
Any number except 16 |
|
> |
Greater than |
Greater than the given number. |
>16 |
Any number higher than 16 |
|
< |
Less than |
Less than the given number. |
<16 |
Any number lower than 16 |
|
>= |
Greater than or equal to |
Greater than or equal to the given number. |
>=16 |
16 or any higher number |
|
<= |
Less than or equal to |
Less than or equal to the given number. |
<=16 |
16 or any lower number |
|
<> |
Not equal |
Not equal to the given number. |
<>16 |
Any number except 16 |
|
- |
Range |
Between the given numbers, inclusive. |
14-16 |
14, 15, or 16 |
Numeric Examples
When you enter data into the QBE field of a numeric column, in a Worklist that supports Advanced QBE, Synapse does the following:
- Performs a search that returns items in the Worklist where the specified property is equal to the specified value (entered in the QBE field) when the numeric value contains no special characters. Additionally, Synapse supports an explicit special character for this operation.
- Removes leading, trailing, and embedded spaces before parsing. For example, input value [space]1[space]2[space]3[space] is converted to 123.
The following are examples of potential search queries using special characters and combinations of special characters.
|
Column |
QBE |
Sample Input Text |
|---|---|---|
|
Image Count |
Is equal to 3 |
3 |
|
Image Count |
Is not equal to 3 |
!3 |
|
Image Count |
Is less than 100 |
<100 |
|
Image Count |
Is greater than 100 |
>100 |
|
Image Count |
Between 3 and 100 inclusive |
3-100 |
|
Image Count |
Is greater than or equal to 100 |
>100|100 |
|
Image Count |
Is not between 3 and 100 |
<3|>100 |