Group data by one value
Group data by one value
Technologies > User Interface Add-Ins > Grouping Views > Grouping DataSource
The grouping Data Source can be used to perform grouping/aggregating SQL queries. Group by fields are included into both the SELECT and GROUP BY clauses of the generated SQL query.
The following example groups rooms by room standard. Note that the grouping data source has
type="grouping"
, and the grouping field is set to
groupBy="true"
:
<dataSource
type="grouping"
>
<table name="rm"/>
<field name="rm_std"
groupBy="true"
/>
</dataSource>
View: http://localhost:8080/archibus/schema/ab-products/solutions/parts/chart/ab-ex-grouping-ds.axvw