startRender count

antoniocib

Hello everyone, I can't figure out how to count how many subgroups there are, I am attaching photos to be clearer

I need to count how many elements circled in red there are

the code is this:

        startRender: function ( rows, group, level ) {

                     if ( level == 1 ) {
                       return group;

                     } else {

                      return group +' ('+rows.count()+' Viaggi)';
                     }
                 },

kthorngren

The level starts at 0 for the first group. For the second group level == 1 you are just returning the group.

Kevin

antoniocib

@kthorngren
I would like to count level 0 how many sublevels it has below, not how many total rows

antoniocib

for example do this:

             if ( level == 0 ) {
               return group +' ('+**level**.count()+' Viaggi)';
 
             } else {
 
              return group +' ('+rows.count()+' Viaggi)';
             }

rf1234

Are you sure that this is your complete code? I think you have 3 nesting levels not just 2, don't you?
Looks like in this example: https://datatables.net/extensions/rowgroup/examples/initialisation/multipleGroups.html

Level 0 is the line with "Viaggi" in it.
Level 1 is the line with the value from "Num Bxd" in it.
Level 2 is all the rest.

And you will also have this in your code:

      rowGroup: {
            dataSrc: [ 10, 8 ]
        },

antoniocib

Okay @rf1234 I know this, I only that I need to count how many NUM BXDs are associated with level 0 and write it in brackets

rf1234

Then post your code ...otherwise it is a lot of guess work for us. Even better: Post a test case.

antoniocib

var table = $('#Buono').DataTable( {

    dom: 'Bfrtip',
    paging: false,
    ajax: {
            url: 'php/table.Buono.php',
            type: 'POST'

    },
    order:[10,8],
    rowGroup: {
        dataSrc: ['buono.autista', 'buono.n_bxd'],

        startRender: function ( rows, group, level, data) {

                     if ( level == 0 ) {
                       return group+' ('+rows.count()+' Viaggi)';


                     } else {
                       return group +' ('+rows.count()+' Scarichi)';
                     }
                 },
columns:[

{
                "data": "buono.id_spedizione",
                orderable:false,
            searchable:false  //0
            },
            {
                "data": "buono.data_spedizione",
                orderable:false,
            searchable:false //1
            },
            {
                "data": "buono.mittente",
                orderable:false,
            searchable:false    //2
            },
            {
                "data": "buono.prov_mittente",
                orderable:false,
            searchable:false //3
            },
            {
                "data": "buono.destinatario",
                orderable:false,
            searchable:false //4
            },
            {
                "data": "buono.loc_destinatario",
                orderable:false,
            searchable:false //5
            },
            {
                "data": "buono.prov_destinatario",
                orderable:false,
            searchable:false //6
            },
            {
                "data": "buono.n_bancali",
                orderable:false,
            searchable:false //7
            },
            {
                "data": "buono.n_bxd" //8
            },
            {
                "data": "buono.data_bxd",
                orderable:false,
            searchable:false    //9
            },
            {
                "data": "buono.autista" //10
            },
            {
                "data": "cond.zona",
                orderable:false,
            searchable:false
        } //11


],
buttons: [
    { extend: 'create', editor: editor },
    { extend: 'edit',   editor: editor },
    { extend: 'remove', editor: editor }
],
language: {
select: {
                        rows: {
                                _: "%d righe selezionate",
                                0: "",
                                1: "1 riga selezionata"
                        }
                },
processing:     "Processando...",
search:         "",
lengthMenu:     " ",
info:           " ",
infoEmpty:      "Mostra 0 su 0 di 0 spedizioni",
infoFiltered:   "",
infoPostFix:    "",
loadingRecords: "Caricamento in corso...",
zeroRecords:    "Nessuna spedizione",
emptyTable:     "Nessuna spedizione disponibile",
paginate: {
        first:     "",
        previous:   "",
        next:       "",
        last:       ""
},
aria: {
        sortAscending:  ": Attivare per ordinare la colonna in modo crescente",
        sortDescending: ": Attivare per ordinare la colonna in modo decrescente"
}
},



} );

antoniocib

This is the code complete.

kthorngren

You will need to iterate through the rows that are passed in and get the unique values for the sub-level columns. I would try using pluck() and unique() for this. Maybe something like this:

var subLevelCount = rows.pluck( 'my_second_level' ).unique().count();

Replace my_second_level with whatever your second level object is.

Kevin

rf1234

That is not the code that produced your picture because the picture doesn't have "Scarichi" in it.

antoniocib

@kthorngren
It always returns 1 this variable that you made

antoniocib

@rf1234 non ho capito cosa intendi

antoniocib

usando questo codice:

startRender: function ( rows, group, level, data) {
if ( level == 0 ) {
 var subLevelCount = rows.pluck( 'buono.n_bxd' ).unique().count();
         return group+' ('+subLevelCount+' Viaggi)';
                     } 
  else {
return group +' ('+rows.count()+' Scarichi)';
      }
                 },

kthorngren

It will probably work better if you add .data() Something like this:

var subLevelCount = rows.data().pluck( 'my_second_level' ).unique().count();

Kevin

antoniocib

@kthorngren nope, not work..

kthorngren

nope, not work..

What happens. Please provide a test case that we can help you with.
https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

Kevin

antoniocib

@kthorngren i dont know how to do a test case..

kthorngren

Please explain what happens instead of just nope, not work.

Kevin

antoniocib

@kthorngren Adding .data () doesn't change anything, it always returns 1

kthorngren

It seems to work here:
http://live.datatables.net/qiquhari/2/edit

Kevin

antoniocib

in this way @kthorngren count all rows below

in this way it counts the lines with the numbers in red, but i need to counts the numbers in blue:

rowGroup: {
    dataSrc: ['buono.autista', 'buono.n_bxd'],

    startRender: function ( rows, group, level) {

             if ( level === 0 ) {
         var subLevelCount = rows.data().pluck( 8 ).count();

            return group+' ('+subLevelCount+' Viaggi)';


                                 } else {
    return group +' ('+rows.count()+' Scarichi)';
                                 }
                         },

},

kthorngren

You are missing the unique() API call.

Kevin

antoniocib

rowGroup: {
    dataSrc: ['buono.autista', 'buono.n_bxd'],

    startRender: function ( rows, group, level) {

     if ( level === 0 ) {
 var subLevelCount = rows.data().pluck( 8 ).unique().count();

         return group+' ('+subLevelCount+' Viaggi)';


     } else {
     return group +' ('+rows.count()+' Scarichi)';
             }
         },

},

antoniocib

@kthorngren with the .unique() return 1

kthorngren

Looks like you are using objects. So pluck should be the object, for example .pluck('buono.n_bxd').

Kevin

antoniocib

@kthorngren always 1 return

kthorngren

I provided an example where it works. You will need to provide a link to your page or an example where its not working so we can help debug.

Kevin

antoniocib

@kthorngren Can give you AnyDesk?

kthorngren

You might be able to arrange purchased support from the developers if you want to arrange a remote login session. Contact Allan or Colin directly to find out details of setting up a remote login session.

Kevin

antoniocib

http://www.comidb.it/pos1/scrivania.php this is the website @kthorngren