Group data by a date range

Technologies > User Interface Add-Ins > Grouping Views > Grouping DataSource using Date Ranges

Grouping fields can also be calculated using a date formula. Supported grouping field formulas are year, quarter, month, week , and day .

Group Action Items by month using the date_requested field:

<dataSource type="grouping" id="ds1">
<table name="activity_log"/>
<field name="month" groupBy="true" dataType="text"
formula="month" baseField="activity_log.date_requested" >
<title translatable="true">Year-Month</title>
</field>
<sortField name="month" ascending="false"/>
</dataSource>

View: http://localhost:8080/archibus/schema/ab-products/solutions/parts/chart/ab-ex-grouping-ds-dates.axvw