Using Advanced QBE

Introduction

Synapse provides the ability for you to use advanced (Query By Example) QBE searches, choosing special characters to refine your search by applying filters to Worklist content. The Advanced QBE feature lets you use a combination of filters and operators to refine your search.

For each text, numeric, and date column that supports Advanced QBE, Synapse provides an editable field into which you can enter a text string, numeric value, or date range.

  • You can apply search characters to all Worklist types.
  • You do not need to add a space between a search character and the value.
  • Some search characters are specific to integer-based columns.
  • See the following table and related topics for details and additional examples.

Note:
  • Synapse returns an empty list result when a query does not or cannot match any content.
  • When you apply QBE to AI columns in the Worklist, a primary filter is required. You cannot use AI columns as primary filters from an All Studies-based Worklist.
  • In some cases, using the advanced QBE characters "/" and "\" can cause a delay of 10 seconds or more before results display. To avoid a potential delay, use leading strings, such as "MRN" without a forward or backward slash.

Steps

  • Select one of the following options and add it to your search value in a QBE field.

Character

Operator

Explanation

Example

Queries For

/

Contains

Contains a given string.

/Contrast

Procedure descriptions with the word Contrast.

\

Does not contain

Does not contain the given string.

\Contrast

Any string that does not contain Contrast.

>

Greater than

Greater than the given number.

>16

Any number higher than 16.

<

Less than

Less than the given number.

<16

Any number less than 16.

|

OR

Disjoins the expressions on either side of the operator.

MR|CT

All MR or CT modalities.

&

AND

Conjoins the expressions on either side of the operator.

-MR&-CT

All modalities except MR and CT.

$

Starts with

Starts with a given string.

$Chest

Procedure descriptions starting with the word Chest.

When the search string contains a character that is also a string operator, the first occurrence of any of the string operators becomes an escape for the next character and the second character is included in the search string.

 

Contains the given string including the - character or the / character.

/-Contrast

//Contrast

Procedure descriptions with the word and character -Contrast.

Procedure descriptions with the word and character /Contrast.

!

Does not start with

Does not start with the given string.

!Contrast

Procedure descriptions that do not start with the word Contrast.

!Cont

Procedure descriptions that do not start with Cont (including Contrast or any other word beginning with Cont).

=

Equals

Equals the given string.

=Contrast

Procedure descriptions that equal Contrast.

Related Topics

Advanced Query by Example Overview