Table Header Grouping

ayoob005 · Août 17, 2021, 10:19

Hi All,

I want to display one grid in which two columns should be under same header, like below screenshot,
The Opening balance is common header for debit and credit column.
Kindly confirm is it possible in Axelor Grid view, If yes, kindly share the code sample to achieve this.

siddique · Août 17, 2021, 12:11

yes, you can create this with custom three columns group by account name, custom views are life saver.

github.com

axelor/open-platform-demo/blob/2940501bffca67752f055bf9e27c2a0365159d4e/modules/demo-sale/src/main/resources/views/Order.xml#L106


    <h1>{{first.total}}</h1>
    <small>Total sale</small>
    <div class="report-percent font-bold pull-right" ng-class="{'text-error': first.down, 'text-success': !first.down}">{{first.percent | number:2}}% <i class="fa" ng-class="{'fa-level-down': first.down, 'fa-level-up': !first.down}"></i></div>
    <div class="report-tags"><span class="label label-success">Monthly</span></div>
  </div>
  ]]>
  </template>
</custom>

<!-- dashboard data table with predefined template tag -->
<custom name="report-sales-list" title="Some Title">
  <field name="total" type="decimal" x-scale="2" />
  <dataset type="jpql" limit="10">
  <![CDATA[
  SELECT self.name AS name, c.fullName AS customer, self.totalAmount AS total FROM Order self
  LEFT join self.customer AS c
  WHERE YEAR(self.orderDate) = YEAR(current_date)
  AND MONTH(self.orderDate) = MONTH(current_date)
  ]]>
  </dataset>
  <template>

ayoob005 · Août 17, 2021, 12:13

Thank you for your update, i will try this