Supported Operators for Repeatable Fields
- Magda Zacharska
- Kathleen Moore
Predefined Fields
Predefined repeatable fields allow users to select values from a list of predefined options.
Examples:
Languages in instance records
Statistical codes in item records
Supported Operators
Operator | Expected Behavior | Example Instance record contains following languages: German, English, French | |
|---|---|---|---|
Following searches will match the record | Following searches will not match the record | ||
Equals | Matches the entire value of any element in the array. The operator takes one value only. |
| Any language that is not associated with the instance |
Not equal to | None of the array elements match the entire search text. The operator takes one value only. | Any language that is not associated with the instance. |
|
In | Equivalent to an OR operator across multiple values.
The operator takes multiple values. |
|
|
Not in | The opposite of the “In” operator.
The operator takes multiple values. |
|
|
Is null/empty | The array is empty. Accepts True or False. | False | True |
Mapping to old (existing) operators
Old operator | Equivalent “new” operator | Differences/notes |
|---|---|---|
contains any | in | rename of existing operator |
not contain any | not in | rename of existing operator |
contains all | equals + Boolean AND for additional values | need to use Boolean to add additional query parameter for each value (rather than passing in multiple values at once) existing queries need to be migrated |
not contains all | not equal to + Boolean AND for additional values | need to use Boolean to add additional query parameter for each value (rather than passing in multiple values at once) Existing queries need to be migrated. |
is null/empty | is null/empty | no change |
Free Text Fields
Free text repeatable fields allow users to enter any text.
Examples:
Administrative notes in instance or item records
Supported Operators
Operator | Expected Behavior | Example Instance record contains following contributors: Stuart, James, 1713-1788 | |
|---|---|---|---|
Following searches will match the record | Following searches will not match the record | ||
Equals | Matches the entire value of any element in the array. The operator takes one value only. |
|
|
Not equal to | None of the array elements match the entire search text.
The operator takes one value only. |
|
|
Contains | Any element in the array contains the search text. Partial matches are supported. The operator takes one value only. |
|
|
Starts with | Any element in the array starts with the search text.
The operator takes one value only. |
|
|
Is null/empty | The array is empty. | False | True |
Wildcard | A special character used in a search to represent unknown or variable characters. | Planned for the Umbrellalaf release | |
Multi-Value Fields
Multi-value repeatable fields contain a mix of predefined and free text values.
Examples:
Notes in instance, holdings, and item records
Each element in a multi-value field supports the operators relevant to its type.
For example:
Note types support operators for predefined fields
Note content supports operators for free text fields