Text String QBE Examples
Introduction
When you enter data into the QBE field of a text 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 begins with the specified string, when the text string contains no special characters. For example, entering xy matches items with values such as xy, xy1, xyzqabcde6. Additionally, Synapse supports an explicit special character for this operation.
- Supports a search that returns only items in the Worklist where the queried property is an exact match. For example, entering =xyl matches only items with value xy.
- Removes leading, and trailing spaces, but keeps embedded spaces. For example, input text [space]x[space]y[space] is trimmed to x[space]y before parsing.
The following are examples of potential search queries using special characters and combinations of special characters.
|
Column |
QBE |
Sample Input Text |
|---|---|---|
|
Modality |
Not CR |
-CR |
|
Modality |
CR or CT |
CR|CT |
|
Modality |
Not CR and Not CT |
-CR&-CT |
|
Procedure Description |
Starts with x |
x |
|
Procedure Description |
Does not start with x |
-x |
|
Procedure Description |
Starts with hyphen |
- |
|
Procedure Description |
Starts with hyphen x |
$-x |
|
Procedure Description |
Contains _ |
/_ |
|
Procedure Description |
Does not contain x |
\x |
|
Procedure Description |
Contains x but not y |
/x&\y |
|
Procedure Code |
In the list of (x, y, z) |
=x|=y|=z |
|
Procedure Code |
Not in the list of (x, y, z) |
-x&-y&-z |
|
Procedure Code |
Contains & |
/&& |