Interface ISqlQuery

interface ISqlQuery {
    aggregateLevel?: AggregateLevel;
    deviceIds?: string[];
    end?: string;
    filters?: string[];
    limit?: number;
    names?: string[];
    notNames?: string[];
    orderByColumn?: string;
    orderByDescending?: boolean;
    parameters?: string[];
    sqlQuery?: string;
    start?: string;
    streamColumns?: IStreamColumn[];
    tags?: ITagSets;
    taskColumns?: ITaskReportColumn[];
    type?: "advanced" | "stream" | "task";
    types?: (keyof IStreamTypeMap)[];
    unit?: string;
    visibleColumns?: string[];
}

Hierarchy (view full)

IFilter
- ISqlQuery

Index

Properties

aggregateLevel? deviceIds? end? filters? limit? names? notNames? orderByColumn? orderByDescending? parameters? sqlQuery? start? streamColumns? tags? taskColumns? type? types? unit? visibleColumns?

Properties

`Optional` aggregateLevel

aggregateLevel?: AggregateLevel

`Optional` deviceIds

deviceIds?: string[]

`Optional` end

end?: string

`Optional` filters

filters?: string[]

`Optional` limit

limit?: number

`Optional` names

names?: string[]

`Optional` notNames

notNames?: string[]

`Optional` orderByColumn

orderByColumn?: string

`Optional` orderByDescending

orderByDescending?: boolean

`Optional` parameters

parameters?: string[]

`Optional` sqlQuery

sqlQuery?: string

`Optional` start

start?: string

`Optional` streamColumns

streamColumns?: IStreamColumn[]

`Optional` tags

tags?: ITagSets

`Optional` taskColumns

taskColumns?: ITaskReportColumn[]

`Optional` type

type?: "advanced" | "stream" | "task"

`Optional` types

types?: (keyof IStreamTypeMap)[]

`Optional` unit

unit?: string

`Optional` visibleColumns

visibleColumns?: string[]