MareFrame DB unaggregated data — mfdb_aggregate

Tell mfdb functions not to aggregate this column, just return all values.

mfdb_unaggregated(omitNA = FALSE, like = c(), not_like = c())

Arguments

omitNA: Skip over rows where column is NA
like: Vector of SQL like expressions to check column against
not_like: Vector of SQL like expressions to check column against

Details

SQL like expessions can use the wildcards "_" to match any character and "

Value

An mfdb_aggregate object that can then be used in querying functions such as mfdb_sample_count

Examples

# All vessels with a name ending with 'e' or 'd'
mfdb_unaggregated(like = c("%e", "%d"))
#> $omitNA
#> [1] FALSE
#> 
#> $like
#> [1] "%e" "%d"
#> 
#> $not_like
#> NULL
#> 
#> attr(,"class")
#> [1] "mfdb_unaggregated" "mfdb_aggregate"