Query Modifiers

Helpers for use in constructing conditions in queries.

Usage

any_of(x)

none_of(x)

equal(x, encoded = FALSE)

not_equal(x, encoded = FALSE)

between(x, y)

not_between(x, y)

greater_than(x, or_equal = FALSE)

less_than(x, or_equal = FALSE)

starts_with(x)

ends_with(x)

contains(x)

like(x)

Source

URL Living Standard

JSON-API: Query Parameters

JSON-API: Query Parameters Details

Arguments

x, y

input

encoded

<lgl> whether to url encode the operator

or_equal

<lgl> append = to > or <

Value

An S7 <class_modifier> object.

Details

Query modifiers are a small DSL for use in constructing query conditions, in the JSON-API format.

Examples

any_of(state.abb[10:15])
#> <any_of>
#>  @ operator: chr "IN"
#>  @ value   : chr [1:6] "GA" "HI" "ID" "IL" "IN" "IA"
none_of(state.abb[1:3])
#> <none_of>
#>  @ operator: chr "NOT+IN"
#>  @ value   : chr [1:3] "AL" "AK" "AZ"
equal(1000)
#> <equals>
#>  @ operator: chr "="
#>  @ value   : num 1000
not_equal(10000.23)
#> <not_equal>
#>  @ operator: chr "<>"
#>  @ value   : num 10000
between(1000, 1100)
#> <between>
#>  @ operator: chr "BETWEEN"
#>  @ value   : num [1:2] 1000 1100
between(0.125, 2)
#> <between>
#>  @ operator: chr "BETWEEN"
#>  @ value   : num [1:2] 0.125 2
try(between(0.95, 0.67))
#> Error in between(0.95, 0.67) : 
#>   x [0.95] must be less than y [0.67]
not_between(1000, 1100)
#> <not_between>
#>  @ operator: chr "NOT+BETWEEN"
#>  @ value   : num [1:2] 1000 1100
not_between(0.125, 2)
#> <not_between>
#>  @ operator: chr "NOT+BETWEEN"
#>  @ value   : num [1:2] 0.125 2
try(not_between(0.95, 0.67))
#> Error in not_between(0.95, 0.67) : 
#>   x [0.95] must be less than y [0.67]
greater_than(1000)
#> <greater_than>
#>  @ operator: chr ">"
#>  @ value   : num 1000
greater_than(0.125, or_equal = TRUE)
#> <greater_than>
#>  @ operator: chr ">="
#>  @ value   : num 0.125
less_than(1000)
#> <less_than>
#>  @ operator: chr "<"
#>  @ value   : num 1000
less_than(0.125, or_equal = TRUE)
#> <less_than>
#>  @ operator: chr "<="
#>  @ value   : num 0.125
starts_with("foo")
#> <starts_with>
#>  @ operator: chr "STARTS_WITH"
#>  @ value   : chr "foo"
ends_with("bar")
#> <ends_with>
#>  @ operator: chr "ENDS_WITH"
#>  @ value   : chr "bar"
contains("baz")
#> <contains>
#>  @ operator: chr "CONTAINS"
#>  @ value   : chr "baz"
like("baz")
#> <like>
#>  @ operator: chr "like"
#>  @ value   : chr "baz"