Get parent datasource data

Question

Greetings,my parent grid and child grid have different datasources. I need parent grid values for aggregate function in my child grid. Is it possible to achieve this ?

Bal.: {{data.sum | number:'1.2-2':'es'}} €

public childGrid: GridModel = { dataSource: VoyageOperatorChargeModel, queryString: "voyageId", allowResizing: true, rowHeight: 25, columns: [ {field:"chargeDesc", headerText:"Charge"}, {field:"invoiceNumber", headerText:"Invoice No.", textAlign: "Right"}, {field:"invoiceDate", headerText:"Inv. Date", textAlign: "Right", type: "date", format:this.format}, {field:"customer.synonim", headerText:"Customer"}, {field:"customerReceiver.synonim", headerText:"Invoice From/To"}, {field:"invoiceAmountDebit", headerText:"Debit", valueAccessor: this.currencyFormatterChild, textAlign: "Right"}, {field:"invoiceAmountCredit", headerText:"Credit", valueAccessor: this.currencyFormatterChild, textAlign: "Right"} ], // aggregates: [{ // columns: [ // {type:"Custom", customAggregate: this.customAggregateDebitChild, columnName:"invoiceAmountDebit", footerTemplate:"Bal: ${Sum}"}, // {type:"Sum", field:"invoiceAmountCredit", columnName:"invoiceAmountCredit", footerTemplate:"Bal: ${Sum}"} // ] // } // ],};

Pavithra Subramaniyam · Accepted Answer

Hi Ivan, 

Thanks for contacting Syncfusion support. 

From your query, We understood that you want to get the parent row detail inside your child Grid custom aggregate function. If yes, you can achieve your requirement by using the below solution. Please refer to the below code example and sample link for more information. 





export class AppComponent { 
  .  .  . 
 
  ngOnInit(): void { 
    this.parentData = employeeData; 
    this.childGrid = { 
      dataSource: orderDatas, 
      queryString: 'EmployeeID', 
      columns: [ 
        { field: 'ShipCountry', headerText: 'Ship Country', width: 120 }, 
        .  .  . 
      ], 
      aggregates: [{ 
          columns: [{ 
              type: 'Custom', 
              customAggregate: this.customAggregateFn, 
              columnName: 'ShipCountry', 
              footerTemplate: 'Brazil Count: ${Custom}' 
          }] 
      }] 
    }; 
  } 
  customAggregateFn(data, aggColumn) { 
    console.log((aggColumn as any).controlParent.parentDetails); 
    return data.result.filter(function (item) { 
      return item[aggColumn.columnName] === 'Brazil'; 
    }).length; 
  } 
} 


Sample: https://stackblitz.com/edit/angular-7qudzt?file=app.component.ts 

Regards, 
Pavithra S

Ivan Galetic · Answer

Hello,Thank you, this solved my problem.Salutations,Ivan

Pavithra Subramaniyam · Answer

Hi Ivan, 

Thanks for your update. 

It is great to hear that the provided solution solved your problem! Please contact us if you have any other queries. As always, We are happy to assist you. 

Regards, 
Pavithra S