Interface GenieAgentSqlSnippets

Reusable SQL snippets.

interface GenieAgentSqlSnippets {
    expressions?: GenieAgentSqlExpression[];
    filters?: GenieAgentSqlFilter[];
    measures?: GenieAgentSqlMeasure[];
}

Index

Properties

expressions? filters? measures?

Properties

`Optional`expressions

expressions?: GenieAgentSqlExpression[]

Non-aggregated expressions (dimensions), such as price * units.

`Optional`filters

filters?: GenieAgentSqlFilter[]

Filters, such as state = 'CA'.

`Optional`measures

measures?: GenieAgentSqlMeasure[]

Aggregated measures, such as SUM(price * units).