ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: EPM Solutions on July 07, 2020, 04:57:06 pm

Title: How can we add a drop down in Group Summary cell with value of grouped column?
Post by: EPM Solutions on July 07, 2020, 04:57:06 pm

Hello Team,

We want to add a drop down (choice) in cell of group column as we are adding in a cell of normal param query grid.

Our requirement is to add a drop down as CO# column in the cell of group column as shown in image.

Can you please help us to add it?

We created an problem plunkr here.

Problem plnkr URL:
https://stackblitz.com/edit/js-vhnf4a?file=index.html

Title: Re: How can we add a drop down in Group Summary cell with value of grouped column?
Post by: paramvir on July 07, 2020, 06:54:06 pm

Please let me know what you want to do with a drop down in the group title column.

Title: Re: How can we add a drop down in Group Summary cell with value of grouped column?
Post by: EPM Solutions on July 08, 2020, 03:00:48 pm

Hello team,

We want to Change the grouping as per the values in drop-down.

We need same functionality in group title as its is working in CO# column.

Suppose if we are selecting CO#2 in place of CO#1 as shown in previous image then items in CO#2 Group title become two as showing in below image.
 
Please if possible update the below plunkr URl with solution.

plunkr URL: https://stackblitz.com/edit/js-vhnf4a?file=index.html

Title: Re: How can we add a drop down in Group Summary cell with value of grouped column?
Post by: paramvir on July 09, 2020, 12:08:31 pm

Thanks for the description, I'm looking into it.

Title: Re: How can we add a drop down in Group Summary cell with value of grouped column?
Post by: paramvir on July 11, 2020, 09:37:06 pm

You could use a change event to update the children values.

Code: [Select]

      change: function(evt, ui){
        //debugger;       
        var ul = ui.updateList[0],
          rowData = ul.rowData,
          newVal = ul.newRow.grp,
          oldVal = ul.oldRow.grp;
        if(rowData.pq_gtitle && newVal){
          rowData.children.forEach(function(rd){
            rd.CO = newVal;
          })
          this.refreshView();//regroup data.         
        }       
      }

https://stackblitz.com/edit/js-mmmpfo?file=index.html