INDEX

Documentation Library

Search for information on Hornbill Documentation.

Filter

This website is Hornbill's new product documentation website and is currently under development.
It is intended that all existing and future public-facing documentation we produce will be available to search, browse and share.
Hornbill's current documentation is available at Hornbill Wiki but over time this content will be migrated to this documentation site.
Please feel free to have a look around at any time.

Hornbill's products have moved on considerably since we introduced it almost 10 years ago. At the time, the MediaWiki tool was sufficient, but we have outgrown it.
Our customers are more enterprise focused and more self-sufficient than ever before, so for 2023 and beyond we have established a new documentation platform and team to drive our documentation initiative forwards.
We are aiming to deprecate the use of Hornbill Wiki for most Hornbill related documentation.
We want to enable our growing partner network with product resources and information, documentation beyond our Wiki approach is required.
We could definitely do with some help, and may even pay for some! If you have domain knowledge and would like to help, please check out our Hornbill Docs Contributor Guide and contact the Hornbill docs team at docs@hornbill.com.

Community contribution will be facilitated, encouraged, and most welcome.
High quality documentation, will be kept up to date as rapidly as our products evolve.
Real-time content search and discovery.
Articles organized into books, books into libraries, creating a more natural and logical structure to our documentation.
Legacy API documentation and various other documentation sources will all be consolidated into a single unified documentation system.
Documentation available in browser as well as printable/viewable as PDF on demand.
Personalized documentation experience, allowing dark/light mode, article subscriptions, social media sharing and other useful features.
Almost all publicly available documentation on docs.hornbill.com will be open-source and available to fork on GitHub, allowing customers to derive their own custom documentation around Hornbill products should they wish to.

We have taken the decision to publish and make available early, there is very little content at this time.
As and when we have completed/usable documentation, it will be published here.
We have a host of additional features we wish to add over time, so please watch this space.
We expect most of our existing documentation should be reviewed/migrated to docs.hornbill.com over the coming months.
The documentation project will be ongoing, will continue to expand, evolve and improve day-by-day.

More...

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

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