Trillium - Querying Repeatable Fields

1. Navigate to the Bulk Edit app.

2. Select the Query tab.

3. Choose the Record Type.

4. Click the Build Query button.

• Creating a New List

  1. Click the New button (top right corner).

  2. Provide a List Name, select Record Type, Visibility, and Status.

  3. Click the Build Query button.

• Updating an Existing List

  1. Click the List Name hyperlink.

  2. From the Actions menu, select Edit List.

  3. Click the Edit Query button.

In FOLIO, repeatable fields are fields that can contain multiple values for a single record. Some of these fields are designed to accept values from a controlled list, meaning users can only select from a predefined set of options.

These are called repeatable fields with predefined values, and they help ensure consistency and data integrity across records.

When searching in repeatable fields the following search options are supported:

Finds records where at least one value in the field exactly matches your search term.

Example: Searching for “English” in the Language field will match records that include “English” among their listed languages.

Finds records where none of the values in the field match your search term.

Example: Searching for “English” will exclude records that list “English” as one of the languages.

Works like an OR search across multiple values.

Example: Searching for “English, French” will return records that include either English or French.

Returns records that do not contain any of the values you specify.

Example: Searching for “English, French” will exclude records that contain either English or French.

Finds records where the field is completely empty (i.e., no values have been entered).

Example: Searching for empty Language field will return records that have no language specified.

Repeatable fields can contain multiple values for a single record. Some of these fields allow users to enter free text, meaning they can type in any information they find relevant.

An example of this is the Administrative notes field, where staff can add multiple notes in plain text.

Other repeatable fields are more structured and include additional elements alongside the free text. For example, Instance notes include the note itself, a predefined note type, and a staff-only flag that can be set to true or false.

These fields offer flexibility while still supporting consistency and control where needed.

When searching in repeatable fields with free text or complex objects, the following search options are supported:

Finds records where at least one value in the field exactly matches your search term.

Example: Searching for Stuart, James, 1713–1788 in the Contributor field will match records that include this exact contributor name.

Finds records where none of the values in the field exactly match your search term.

Example: Searching for Stuart, James, 1713–1788 will exclude records that list this contributor.

Finds records where at least one value in the field includes your search term anywhere within the text.

Example: Searching for Stuart will match records that include Stuart, James, 1713–1788 or any other contributor name that contains "Stuart".

Finds records where at least one value in the field begins with your search term.

Example: Searching for Revett will match records that include Revett, Nicholas, 1720–1804.

Finds records where the field is completely empty (i.e., no values have been entered).

Example: Searching for empty Contributor field will return records that have no contributors listed.

When searching in fields with true/false values, the following search options are supported:

Finds records where the field is set to either true or false, depending on your search term.

Example: Searching for true in the Staff only field will return records where the note is marked as visible to staff only.

Finds records where the field value does not match your search term.

Example: Searching for false will return records where the Staff only field is set to true.

Finds records where the field has no value set—meaning it’s neither true nor false.