Create a table that is based on an aggregate query against an existing table.
Namespace: StreamBase.LiveView.APIAssembly: StreamBase.LiveView.API (in StreamBase.LiveView.API.dll) Version: 10.6.1.0 (10.6.1.0)
Syntax
C# | Visual Basic | Visual C++ |
void CreateAggregateTable( string tablename, string descripton, QueryConfig aggregateQuery, IList<IList<string>> indices )
Sub CreateAggregateTable ( _ tablename As String, _ descripton As String, _ aggregateQuery As QueryConfig, _ indices As IList(Of IList(Of String)) _ )
void CreateAggregateTable( String^ tablename, String^ descripton, QueryConfig^ aggregateQuery, IList<IList<String^>^>^ indices )
Parameters
- tablename
- String
- descripton
- String
- aggregateQuery
- QueryConfig
Definition of the query against an existing table which that provide the source of data for this new one.
- indices
- IList<(Of <(<'IList<(Of <(<'String>)>)>>)>)>
Each index is a list of field names; the first index in the list is the primary key, and the rest are secondary keys. Primary key must match the group-by of the query, or the aliased version of the group-by of the query.