Topics

106

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.

107

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.

108

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.

109

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?

110

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...

111

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...

112

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.

113

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

114

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