help:array syntax

When searching by arrays, the following variations on search parameters can be used.

Whitespace separated lists

These parameter variations use whitespace (spaces, tabs, linebreaks) as a separator for the array, regardless of whether the individual items are numbers or text. This is the default and has no qualifier.

Array separated lists

These parameter variations use the URL array format (Help:Array format) to input the separate search items. Is denoted with the qualifier "array".

Lowercase lists

These parameter variations apply a lowercase transformation to both the input and the record fields when making the comparisons. Is denoted with the qualifier "lower".

Includes any

Will return all records that include any of the items from the array. Is denoted with the qualifier "include_any".

Includes all

Will return all records that include all of the items from the array. Is denoted with the qualifier "include_all".

Any matches regex

Regex equality comparison against each value in the record's array. Follows Postgres' ERE regex formatting rules (see External links below).

Count

Searches using the count of items in the array. Uses the same parameter format as numbers (see Help:Number syntax).

All parameter variations

For the following, NAME is the name of the record field being searched for, and SINGULAR is the singular name of that record field.

  • NAME_include_any
  • NAME_include_all
  • NAME_include_any_array
  • NAME_include_all_array
  • NAME_include_any_lower
  • NAME_include_all_lower
  • NAME_include_any_lower_array
  • NAME_include_all_lower_array
  • any_SINGULAR_matches_regex
  • SINGULAR_count

See also