custom_query: Flexible template for queries with single-column results

View source: R/custom_query.R

custom_queryR Documentation

Flexible template for queries with single-column results

Description

This functions provides a shorthand for queries of the form "select x from (standalone-query) where ... group by ... having ..."

Usage

custom_query(custom, id_field, id_type, where = NULL, having = NULL)

Arguments

custom

A SQL query (as a character vector of length 1)

id_field

the name of the id column in custom

id_type

a text label for the type of id

where

pre-aggregated filter conditions

having

post-aggregated filter conditions

Details

This function is similar to aggregate_q except the source is not constrained to being a single table, it can be any query.


tarakc02/listbuilder documentation built on Jan. 27, 2024, 7:48 p.m.