Documentation

This is taking longer than usual. If nothing appears, refresh the page.

Documentation

    {{docApp.userSession.userId}}
    {{docApp.userSession.userName}}
    {{docApp.userSession.email}}
    Issuer : {{docApp.userSession.issuerInstance}}
    Expires : {{new Date(docApp.userSession.validUntil).toLocaleDateString()}}

{{docApp.title}}

{{docApp.description}}

Connect an AI assistant

Your AI assistant can read this documentation directly, so it answers from the current content instead of guessing. Add one of the servers below to your client — they use the Model Context Protocol (MCP). Each one covers a different body of content, so add the one you need.

The catalog did not load. Refresh the page to try again.

Loading…

How can we help?

{{docApp.searchError}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

 {{docApp.currentResultsSearchText}}  in {{docApp.searchFilterBySpecificBookTitle}}
Found {{docApp.searchResponse.totalResultsAvailable}} matches. Showing the top {{docApp.searchResponse.results ? docApp.searchResponse.results.length : 0}}. Use a more specific search to further narrow down the results.
No documentation pages match this search, so all content types are shown. Most matches are in {{docApp.searchDocTypeRescue.best.name}}.
There is no book with the ID "{{docApp.searchBookRescue.bid}}", so the book filter from this link was ignored and results from all books are shown.

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

  • {{resultItem.title}} {{resultItem.matchedBy === 'semantic' ? 'semantic' : (resultItem.matchedBy === 'both' ? 'keyword + semantic' : 'keyword')}}

    {{resultItem.url}}

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

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

Complex Types - widgetChartDataSeriesSqlGroup

  • Article
  • 1 minutes to read

Description

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

Properties

Name Type Occurrence Description
show orderDirectionType Required show in ascending/descending order
sample xs:integer Required number of rows to return
fromTable xs:string Required select from table
groupColumn xs:string Required column to group on
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.
filter xs:string Optional where caluse filter
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.
drilldownColumns xs:string Optional comma seperated columns to select when doing drilldown
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document