Messages

301

Help for ParamQuery Pro / Set new value based on other value

« on: October 06, 2016, 12:43:46 pm »

Im trying to use render function to set a new cell value in other column depending on an if statement:

Code: [Select]

render: function (ui) {
if (condition) {
        return "test" + ui.cellData; // this is the only line executed
        ui.rowData.column1 = "test"; // this line does not work, however it works if above line is removed
        }
}
Thanks in advance.

302

Suggest new features / Re: Hide / show columns vs saveState

« on: August 30, 2016, 04:48:44 pm »

Hi

Is there any update on this? Tried v3.3.2, but it still doesn't seem to work.

303

Help for ParamQuery Pro / Updating filters

« on: June 29, 2016, 02:16:56 am »

Hi

Is it possible to only show possible filters (that will give match) for column 2 depending on what chosen as filter in column 1?
Im using pqSelect and currently it show all possible values even though it will result in zero matches.

Thanks.

304

Suggest new features / Hide / show columns vs saveState

« on: June 28, 2016, 02:00:45 am »

I have an issue with shown/hide columns not saved to saveState...

Toolbar code:

Code: [Select]

{
                        type: 'select',
                        cls: 'columnSelector',
                        attr: "multiple='multiple'", style: "height:60px;",
                        options: function (ui) {
                            var CM = this.getColModel(),
                                opts = [];
                            for (var i = 0; i < CM.length; i++) {
                                var obj = {},
                                    column = CM[i];
                                   
                                obj[ column.dataIndx ] = column.title;
                                opts.push(obj);
                            }
                            return opts;
                        },
                        listener: function (evt) {
                            var arr = $(evt.target).val(),
                                CM = this.getColModel();

                            for (var i = 0; i < CM.length; i++) {
                                var column = CM[i],
                                    dataIndx = column.dataIndx;

                                //hide the column if not a selected option.
                                column.hidden = ($.inArray(dataIndx, arr) == -1);
                            }
                            this.option("colModel", this.option("colModel")); //refresh the colModel.
                            this.refresh();
                        }
                    }
Function code:

Code: [Select]

create: function (evt, ui) {
                    var CM = this.getColModel(),
                        opts = [];
                    for (var i = 0; i < CM.length; i++) {
                        var column = CM[i];
                        if (column.hidden !== true) {
                            opts.push(column.dataIndx);
                        }
                    }
                    //initialize the selected options in toolbar select list.
                    $(".columnSelector").val(opts);

                    //convert it into pqSelect.
                    $(".columnSelector").pqSelect({
                        checkbox: true,
                        multiplePlaceholder: 'SELECT VISIBLE COLUMNS',
                        maxDisplay: 0, //100
                        width: '180px', //auto
                        displayText: 'SELECT VISIBLE COLUMNS'
                    });
                }
All other states is saved correctly.

305

Help for ParamQuery Pro / Re: exportData

« on: June 17, 2016, 07:03:37 pm »

Great, thanks.
I assume its not possible to use render: false and still have the percentage sign written out in the export, or is there another way to do it?

Code: [Select]

render: function (ui) {
                   
           return "<span>"+ ui.cellData +"%</span>";
           }


306

Help for ParamQuery Pro / exportData

« on: June 17, 2016, 03:42:09 pm »

Hi

When using exportData function, I get the rendered html code for the field.

Ex:

Code: [Select]

render: function (ui) {
                   
           return "<span>"+ ui.cellData +"</span>";
           }

Will in export be <span>value</span>...I only want to get the value...

Is this possible?

307

Help for ParamQuery Pro / Re: Issue with v3.3.1

« on: June 16, 2016, 02:15:24 pm »

Solved.

308

Help for ParamQuery Pro / Issue with v3.3.1

« on: June 16, 2016, 02:14:22 am »

Hi

I upgraded to v3.3.1 from v3.2.0 and have an issue with the filters:

Code: [Select]

//var $grid = $("#grid_array").pqGrid( obj ); //3.2.0
                var $grid = pq.grid("#grid_array", obj ); //3.3.1

                var column = $grid.pqGrid("getColumn", { dataIndx: "column1" });
                var filter = column.filter;
                filter.cache = null;
                filter.options = $grid.pqGrid("getData", { dataIndx: ["column1"] });
now gives error: $grid.pqGrid is not a function...

309

Help for ParamQuery Pro / Re: Clear filters v3.2.0

« on: June 08, 2016, 06:14:48 pm »

Thanks. Modified code:

Code: [Select]

{ type: 'button', label: 'Clear Filters', listeners: [
     {
      "click": function (evt, ui) {

          var CM = $grid.pqGrid( "getColModel" );
                        for(var i=0, len = CM.length; i < len; i++){
                            var column = CM[i];
                            if(column.filter){
                                column.filter.value = null;
                                column.filter.cache = null;
                            }
                        }
                        $grid.pqGrid( "refreshHeader" );
            $grid.pqGrid( "filter" );({
                oper: 'replace',
                data: []
            });

       }
 }
]
}
now gives: "Uncaught TypeError: Cannot read property 'apply' of undefined"...

310

Help for ParamQuery Pro / Clear filters v3.2.0

« on: June 08, 2016, 02:00:23 pm »

Hi

Trying to creatte button to clear filters with code:

Code: [Select]

{ type: 'button', label: 'Clear Filters', listeners: [
     {
      "click": function (evt, ui) {

          var CM = $grid.pqGrid.getColModel();
                        for(var i=0, len = CM.length; i < len; i++){
                            var column = CM[i];
                            if(column.filter){
                                column.filter.value = null;
                                column.filter.cache = null;
                            }
                        }
                        $grid.pqGrid.refreshHeader();
            $grid.pqGrid.filter({
                oper: 'replace',
                data: []
            });

       }
 }
]
}
but get error: Uncaught TypeError: $grid.pqGrid.getColModel is not a function...

311

Help for ParamQuery Pro / save multiple states of grid in Localstorage

« on: March 06, 2016, 02:48:45 am »

Hi

Im using the saveState and loadState functions which works fine. Now I would like to have the possibility to save and load different states.
Example: I save current state with a user input name which then will be available in a loadstate dropdown. This mean the user can save states and then choose to load a certain state. Preferably also with the possibility to rename or delete a state.

Would that be possible and how could a solution for that look like?

Thanks.

312

Help for ParamQuery Pro / Re: empty cells and sorting

« on: March 06, 2016, 02:04:45 am »

thanks, however tried:

Code: [Select]

...
sortType: function(rowData1, rowData2, dataIndx){
        //compare rowData1[dataIndx] and rowData2[dataIndx]
var c1 = rowData1[dataIndx],
                        c2 = rowData2[dataIndx]
                        //c1 = $.trim(val1).length,
                        //c2 = $.trim(val2).length;

                    if (c1 > c2) {
                        return 1;
                    }
                    else if (c1 < c2) {
                        return -1;
                    }
                    else {
                        return 0;
                    }
but can't get it to work...im not sure I understand how to implement it...

313

Help for ParamQuery Pro / empty cells and sorting

« on: March 03, 2016, 04:25:31 pm »

hello

I have som empty cells in a column with datatype "integer"...these are not correctly sorted and mixes with '0' values in a not wanted way...is there a solution for this?

thanks

314

Help for ParamQuery Pro / Re: filter in column with datatype integer

« on: February 08, 2016, 03:10:02 pm »

tried:

Code: [Select]

{title:"columnd", width:90, dataIndx: "columnd", dataType: "integer", filter: { type: 'textbox', condition: function(a, b){
    if ( ( a + "" ).indexOf( ( b + "" ) ) >= 0 ){
        return true;
    }, listeners: ['keyup']}
}},

doesn't work...where to place the callback to function properly?

thanks

315

Help for ParamQuery Pro / filter in column with datatype integer

« on: February 07, 2016, 09:02:09 pm »

Hi

I use in ColModel

...
dataType: "integer", filter: { type: 'textbox', condition: 'begin',
...

when I use condition: 'contains' I get error: "Uncaught TypeError: f is not a function"

How can I use datatype integer and filter with contains condition?

thanks