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, [code]NAME[/code] is the name of the record field being searched for, and [code]SINGULAR[/code] is the singular name of that record field.
- [code]NAME_include_any[/code]
- [code]NAME_include_all[/code]
- [code]NAME_include_any_array[/code]
- [code]NAME_include_all_array[/code]
- [code]NAME_include_any_lower[/code]
- [code]NAME_include_all_lower[/code]
- [code]NAME_include_any_lower_array[/code]
- [code]NAME_include_all_lower_array[/code]
- [code]any_SINGULAR_matches_regex[/code]
- [code]SINGULAR_count[/code]
See also
External links
- Postgres article on regular expressions
- https://github.com/danbooru/danbooru/blob/master/app/logical/concerns/searchable.rb