Documentation

{{docApp.title}}

{{docApp.description}}

How can we help?

{{docApp.searchError}}
{{product.name}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

{{docApp.searchResultFilteredItems.length}} results for: {{docApp.currentResultsSearchText}} in {{docApp.searchFilterBySpecificBookTitle}}
Search results have been limited. There are a total of {{docApp.searchResponse.totalResultsAvailable}} matches.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

{{group.title || group.id}}

{{group.description}}

  1. {{book.title}}

{{group.title}}

Complex Types - widgetChartDataSeriesSqlGroup

Description

Defines how to get sql group by data for a chart data series.

Properties

Name Type Occurrence Description
aggregate aggregationType Optional
Default=COUNT
Aggregate function to apply.
aggregateColumn xs:string Required column to apply aggregate function on. Currently only functions on numeric type columns are supported. supplying non-numeric types may result in unpredictable behavior.
drilldownColumns xs:string Optional comma seperated columns to select when doing drilldown
filter xs:string Optional where caluse filter
fromTable xs:string Required select from table
groupColumn xs:string Required column to group on
periodFilter samplePeriodFilterType Optional Specify this to restrict samples from a given time range
periodFilterColumn xs:string Optional If period filter is supplied then specify the column on which that period filter should be applied. This column must be of date time type.
sample xs:integer Required number of rows to return
show orderDirectionType Required show in ascending/descending order
In This Document