Advanced Filter

words

require every word to be present, e.g.: some search keywords

phrases

use quotes for multi-word phrases, e.g. "police car"

negation

look for “everything but”, e.g. police -uniform, -"police car" , police NOT car

logical keywords

make logical constructs using AND, OR, &&, ||, &, | operators, e.g. uniform OR car, scoped && search

parentheses

to structure logic e.g. "police AND (uniform OR car)"

explicit fields

search only in the given field. e.g. binomial_name = Brachypelma, created_at > 2009-01-01

Field nameField typeExample
name String name = Precious
binomial_name String binomial_name = gorilla
vernacular String vernacular = python
batch_count Integer batch_count > 1
created_at DateTime create_at > 2014-09-19
updated_at DateTime updated_at < 2015-09-19
born_at DateTime born_at > 2014-09-19
death_at DateTime death_at > 2014-09-19
age Duration age > 1y4mos or age < "15 days"
gender String gender = female
weight String  
length String  
group.name String group.name = cat
group.description String group.description = humid
parse-able strings

Examples of parse-able strings:

  • '12.4 secs'
  • '1:20'
  • '1:20.51'
  • '4:01:01'
  • '3 mins 4 sec'
  • '2 hrs 20 min'
  • '2h20min'
  • '6 mos 1 day'
  • '47 yrs 6 mos and 4d'
  • 'two hours and twenty minutes'
  • '3 weeks and 2 days'

comparison operators

to search in numerical or temporal fields, e.g. > 22, < 2009-01-01

OperatorNotes
= A case sensitive equality comparison for text fields, a normal equality comparison for numerical and temporal fields
!=, &lt;&gt; The inverse/negation of the = operator
~ Case insensitive occurrence/contains search for textual fields (i.e. LIKE/ ILIKE)
!~ The inverse/negation of the ~ operator ( NOT LIKE/ ILIKE)
> Greater than. Only supported for numerical and temporal fields
< Less than. Only supported for numerical and temporal fields
>= Greater than or equals. Only supported for numerical and temporal fields
<= Less than or equals. Only supported for numerical and temporal fields

NULL checks

using the set? and null? operator with a field name, e.g.null? graduated_at, set? parent_id

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk