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
Comments
0 comments
Please sign in to leave a comment.