aggregate_q_: Template for single-table aggregate queries

In tarakc02/listbuilder: Prospecting tool

Template for single-table aggregate queries

Description

This functions provides a shorthand for queries of the form "select x from y where ... group by ... having ..."

Usage

aggregate_q_(table, id_field, id_type, where = NULL, having = NULL, schema)

Arguments

table	full name of the CDW table (eg d_entity_mv)
id_field	the name of the id column in table
id_type	a text label for the type of id
where	pre-aggregated filter conditions
having	post-aggregated filter conditions
schema	the schema
env	evaluation environment

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