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!
-
{{resultItem.title}}
{{resultItem.url}}
{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}
{{docApp.libraryHomeViewProduct.description}}
{{group.title || group.id}}
{{group.description}}
Description
The structure of the report sql select query. this is used to build the actual sql select statement
Properties
Name | Type | Occurrence | Description |
---|---|---|---|
countColumn |
xs:string |
Optional | the count column for the report (if doing a count report) |
groupColumn |
xs:string |
Optional | the group on column for the report (if doing a group by report) |
queryMetaData |
xs:string |
Optional | JSON meta data for extensibility. |
rowLimit |
xs:integer |
Optional | Set to a number if you want to limit the number of rows returned |
selectColumns |
reportDataSourceSelectColumnDefinition |
Required | columns to select |
tables |
reportDataSourceTablesDefinition |
Required | tables to join |
whereClause |
reportDataSourceQueryPart |
Optional | report where clause structure |
- Version {{docApp.book.version}}
- Node {{docApp.node}} / {{docApp.build}}
In This Document