pasteLimitRestrictions: Paste inequality restrictions to a SQL query

In talithafs/dzVis-Package: Data Visualization with Data Zoom

Description

Concatenates inequality restrictions and an existing SQL query string

Usage

pasteLimitRestrictions(query, restrictions, whereClause = FALSE)

Arguments

query	A character value. Initial value of the query string. Restrictions will be pasted after it.
restrictions	A n x 3 matrix with n inequality restrictions. See the details section for important information.
whereClause	If set to TRUE, a 'where' clause is inserted before the restrictions If set to FALSE, an 'and' clause is inserted

Details

The restrictions matrix must have the following columns:

1. targetColumn: A character value. Column on which restrictions should apply.

2. min: A numeric value. Lower bound for the targetColumn. Should be set to NA when not applicable.

3. max: A numeric value. Upper bound for the targetColumn. Should be set to NA when not applicable.

Value

A character. The new query string.

talithafs/dzVis-Package documentation built on May 31, 2019, 2:54 a.m.