The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

Operators

library(queryBuilder)

The article describes default set of operators offered by queryBuilder. Each operator generates expression that can be use to perform various filtering operations.

listQueryOperators()
#> equal: ==
#> not_equal: !=
#> in: %in%
#> not_in: !`%in%`
#> less: <
#> less_or_equal: <=
#> greater: >
#> greater_or_equal: >=
#> between: queryBuilder::in_range
#> not_between: !queryBuilder::in_range
#> begins_with: startsWith
#> not_begins_with: !startsWith
#> contains: queryBuilder::in_string
#> not_contains: !queryBuilder::in_string
#> ends_with: endsWith
#> not_ends_with: !endsWith
#> is_empty: queryBuilder::is_empty
#> not_is_empty: !queryBuilder::is_empty
#> is_null: is.na
#> not_is_null: !is.na

Operators viable for any type of field:

equal - check if field elements equal the provided value

not_equal - check if field elements are different from the provided value

in - check if field elements matches the provided set of values

not_in - check if field elements do not match the provided set of values

is_null - check if field elements are missing (NA)

not_is_null - check if field elements are different from the provided value

Operators viable for numerical and date/time based fields:

less - check if field elements are lesser than the provided value

less_or_equal - check if field elements are lesser or equal the provided value

greater - check if field elements are greater than the provided value

greater_or_equal - check if field elements are greater or equal the provided value

between - check if field elements fit within the provided range (boundary excluded)

not_between - check if field elements do not match the provided set of values (boundary included)

Operators viable for character fields:

begins_with - check if field elements start with the provided string value

not_begins_with - check if field elements do not start with the provided string value

contains - check if field elements start with the provided string value

not_contains - check if field elements do not start with the provided string value

ends_with - check if field elements end with the provided string value

not_ends_with - check if field elements do not end with the provided string value

is_empty - check if field elements are an empty string

not_is_empty - check if field elements are not an empty string

In order to set custom operators please check setQueryOperators().

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.