Group data by a calculated field
Group data by a calculated field
Technologies > User Interface Add-Ins > Grouping Views > Grouping DataSource by a Calculated Field
Group data by a calculated field using an SQL expression:
<field name="dv_and_dp"
groupBy="true"
dataType="text">
<title>Division and Department</title>
<sql dialect="generic">RTRIM(dv_id)${sql.concat}'-'${sql.concat}RTRIM(dp_id)</sql>
</field>
The
${sql.concat}
binding expression is further discussed under
Binding Sources: SQL
Note that sort fields can refer to either grouping or calculated fields by their names:
<sortField name="dv_and_dp" ascending="true"/>
View: http://localhost:8080/archibus/schema/ab-products/solutions/parts/chart/ab-ex-grouping-ds-sql.axvw