ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: sshede on January 06, 2021, 07:13:18 pm

Title: not set groupoption
Post by: sshede on January 06, 2021, 07:13:18 pm

when i try set groupoption by below code then working

grid.Group().option({
                dataIndx: ["FundShortName","CashAccount"]
});


but below code not working

var groupRowString='"FundShortName","CashAccount"';
grid.Group().option({
                dataIndx: [groupRowString]
});

Title: Re: not set groupoption
Post by: paramvir on January 07, 2021, 01:58:28 pm

it's because your 2nd code is incorrect.

Correct one is

Code: [Select]

var groupRowString='FundShortName,CashAccount';
grid.Group().option({
                dataIndx: groupRowString.split(",")
});


Title: I tryed your example but not working Group change by dropDown
Post by: sshede on January 07, 2021, 03:31:17 pm

I tryed your example but not working Group change by dropDown

I have below changes in your exmplae - "Row grouping".
 1) Add html part

<select id='pivotDropDown' >
                <option value="-1">Select Group</option>
                <option value="sport,athlete">View 1</option>
                <option value="Country,age">View 2</option>
            </select>

2) javascript

$("#pivotDropDown").change(function(){
            grid.Group().option({ dataIndx: [] });
            var GM = grid.option("groupModel");
            var groupOptionArr=$("#pivotDropDown").val()
            var groupRowArr=groupOptionArr.split(",");
            for(var i=0;i<groupRowArr.length;i++){
                GM.dataIndx.push(groupRowArr);
            }
            grid.refreshDataAndView()
        })

Title: Re: not set groupoption
Post by: paramvir on January 07, 2021, 08:46:17 pm

Please correct your code

HTML:

Code: [Select]

<select id='pivotDropDown' >
    <option value="-1">Select Group</option>
    <option value="sport,athlete">View 1</option>
    <option value="country,age">View 2</option>
</select>

js:

Code: [Select]

$("#pivotDropDown").change(function(){
    var val = $(this).val();
    grid.Group().option({
dataIndx: val == -1? []: val.split(",")
    });
})