GroupingFeature: Use a other column for Group Title in uniDBGrid

[erich.wanker]

Hi,

i use following code to display the total count of a Group in the Groupheade

function beforeInit(sender, config) 
{
    var groupingFeature = Ext.create('Ext.grid.feature.Grouping', {
        groupHeaderTpl: new Ext.XTemplate(
            '{columnName}: {name} ({[this.countTotal(values.rows)]})',
            '', {
                countTotal: function(records) {
                    var totalSum = 0;
                    totalSum = records.length;
                    return totalSum;
                }
            }
        ),
        hideGroupedHeader: true
    });
    config.features = [groupingFeature]
}

My basic Groupfield is GROUPNUMBER  (this is not changeable)

So the outpu of GroupHeader is: Groupnumber 12345 (999)  

Now i want to ADD the value of database-field "groupname" 

It should output a GroupHeader: Groupnumber 12345  - Groupname This is a Textttext stored in the field "groupname"   (999)  

 

i found this source from mhmda:

function beforeInit(sender, config)
{ 
 config.groupingFeature = Ext.create('Ext.grid.feature.Grouping',{
   groupHeaderTpl:new Ext.XTemplate('{[this.getGroupTitle(values.rows[0])]}',
    {
      getGroupTitle: function(values) {
             if(values.data[1]=='') 
              return 'My custom title: '+values.data[8];/*<--[8]field index*/
             else 
              return 'Other title: '+values.data[2];/*<--[2]field index*/
        }
     })   
  });  
  config.features= [config.groupingFeature];
 }

how can i combinate this two things???

 

[erich.wanker]

i inserted following:

'{columnName}: {name} - Gruppenname:  {values.data[20]}   ({[this.countTotal(values.rows)]})',

but it doesnt put out the values from field "groupname" with ColIndex 20 in this case

 

[Sherzod]

Hello Erich,

Do you have a simple testcase to check?

[erich.wanker]

TESTCASE 

 

Between Output of CountryGroup       and      TotalCount      i want the value of field "City" 

Description: My Datastructure is simmilar to the records of Group "British West Indies" - all "Citys" are the same .. which record of the group is used to get the "Grand Cayman"-Text doesnt matter 

testcase.zip

[Hayri ASLAN]

20 hours ago, erich.wanker said:

TESTCASE 

 

Between Output of CountryGroup       and      TotalCount      i want the value of field "City" 

Description: My Datastructure is simmilar to the records of Group "British West Indies" - all "Citys" are the same .. which record of the group is used to get the "Grand Cayman"-Text doesnt matter 

testcase.zip 32.58 kB · 1 download

Hello

Please use below code. (Please use children instead of rows and rows is deprecated)

PRO TIP : add {[console.log(values)]} into groupHeaderTpl to see the values in the console.

function beforeInit(sender, config)
{
                      config.groupingFeature = Ext.create('Ext.grid.feature.Grouping', {
                        groupHeaderTpl: new Ext.XTemplate('{[this.getGroupTitle(values.rows[0]]}', {
                            getGroupTitle: function (values) {
                                if (values.data[0] == '')
                                    return 'Alle 8D Änderungsreporte ohne Gruppenzuordnung';
                                else
                                    return 'Gruppenname: <b>' + (values.data[0]).replace(/[&\/\\#,+()$~%.":*?<>{}]/g, "");
                                '</b>';
                            }
                        })
                    });
                    config.features = [config.groupingFeature];
                    var groupingFeature = Ext.create('Ext.grid.feature.Grouping', {
                        groupHeaderTpl: new Ext.XTemplate('{columnName}: {name} - 1st CountryName: {[values.children.at(0).get(4)]}   -  TotalCount: ({[this.countTotal(values.children)]})', '', {
                            countTotal: function (records) {
                                var totalSum = 0;
                                totalSum = records.length;
                                return totalSum;
                            }
                        }),
                        hideGroupedHeader: true
                    });
                    config.features = [groupingFeature]
}

[erich.wanker]

WOW 🙂 

 

PERFECT !!! Thank YOU !!!!!

Works great !!