Advanced QBE Search Considerations
Multiple Operations
The data entered by a user into the QBE field of a Worklist (that supports Advanced QBE) can specify multiple operations joined by binary operators. Synapse does the following:
- Supports a special character to specify to link together operations using a logical AND operation
- Supports a special character to specify to link together operations using a logical OR operation
Empty (Null) Value Evaluation
Stored data includes empty (or null) values, for fields where there is no required content, and for which no data has been received. When evaluating such data for Advanced QBE operations, Synapse follows specific rules for handling empty values:
- Will not match items with empty values when performing a QBE operation. For example, if you enter ABC as a location for QBE, the results will only contain appropriately matched items, and no items where the location is empty (null).
- Will return items with empty values when performing a not QBE operation. For example, if you enter not ABC as a location for QBE, the results will contain appropriately matched items, and items where the location is empty (null).
Special Characters Handling
Advanced QBE escapes the following characters:
- Ampersand (&)
- Vertical bar (|)
- Single quote / apostrophe ( ' )
To search for strings containing the special (reserved) characters described above, it is necessary to escape the character by specifying it twice.
The following are examples of potential search strings using special characters and combinations of special characters.
|
Search String |
Description |
|---|---|
|
a&&b |
Finds results starting with a&b |
|
a|||b |
Finds results starting with a| or starts with b |
|
|||ab |
Finds results starting with | or start with ab |
|
ab&&& |
Finds results starting with ab& AND no filter |