Use of 'IN' operator searching documents in Legal Review

SYMPTOMS

There are 2 conditions where it is possible to use the 'IN' operator for document searches. Each condition has its own set of caveats that have to be observed when building search queries in Legal Review.

CAUSE

Not applicable

RESOLUTION

Format: IN FIELD { QUERY }, where FIELD is the name of the field being queried and QUERY is a value(s) to search for within the field.

Condition 1: Field is non full-text searchable

• Multiple values, if applicable, inside the query string must be split with OR operator.
• All values must be the same data type as the field (Number, Text).
• The query is executed by Legal Review against matter document table in database.

Example: IN ID { 40254 or 40252 or 40255 }

Case 2: Field is full-text searchable

• Any valid full-text query can be used.
• The query will be executed by search engine

Example: IN emailsubject { happy new year }

APPLIES TO

3.11, 3.12