Returning null/empty values in Lists / FQM

not equal to [value]

1. date

2. integer

3. string

empty strings are returned, but null values are not

records with null / empty values are returned

e.g., “User – Created date” not equal to “11/11/2025” returns records with null/empty values

4. array of strings

N/A

(operator not available in Sunflower)

records with null / empty values are returned

e.g., “Instance – Language” not equal to “English” returns records with null/empty values

5. boolean

empty strings are returned, but null values are not when value is set to “true”

records with null / empty values are returned when value is set to “true”

e.g., “User – Active” not equal to “true” returns records with null/empty values

empty strings are returned, but null values are not when value is set to “false”

records with null / empty values are returned when value is set to “false”

e.g., “User – Active” not equal to “false” returns records with null/empty values

not in [value]

1. string

2. UUID*

empty strings are returned, but null values are not

*if the query includes an invalid UUID, null values are returned

records with null / empty values are returned

e.g., “Patron group – Name” not in “staff, faculty” returns records with null/empty values

3. array of strings

4. array of UUIDs

N/A

(the equivalent operator Sunflower was not contains any)

records with null / empty values are returned

e.g., “Instance – Language” not in to “English, French” returns records with null/empty values

is null / empty

1. boolean

2. date

3. integer

4. string

5. UUID

6. array of UUIDs

null / empty values are returned when value is set to “true”

records with null / empty values are returned when value is set to “true”

e.g., “User – Active” is null/empty “True” returns records with null/empty values

null / empty values are not returned when value is set to “false”

records with null / empty values are not returned when value is set to “false”

e.g., “User – Active” is null/empty “False” does not return records with null/empty values

7. array of strings

null / empty values are returned when value is set to “true”

(note: Sunflower only supported arrays of strings with defined values)

null / empty values are returned when value is set to “true” - if any of the values for the field are empty, the record matches

e.g., “Instance – Contributors – Type, free text” is null/empty “True” returns a record with two Contributors, one with a populated “Type, free text” and one null or empty “Type, free text”

null / empty values are not returned when value is set to “false”

(note: Sunflower only supported querying arrays of strings with defined values)

null / empty values are not returned when value is set to “false” - only matches if all of the values for the field are non-empty

e.g., “Instance – Contributors – Type, free text” is null/empty “False” does not return the record with two Contributors, one with a populated “Type, free text” and one null or empty “Type, free text”

not contains all

1. array of strings

2. array of UUIDs

null / empty values are returned

N/A

This operator is not available in Trillium

not contains any

1. array of strings

2. array of UUIDs

null / empty values are returned

N/A

The equivalent operator in Trillium is “not in”