Messages

1

Help for ParamQuery Grid (free version) / How to avoid pqSelect reload when pqGrid is refreshed with refreshDataAndView

« on: December 27, 2017, 01:23:23 pm »

Hi everyone,

I bind with signalr clients' pqgrid. When a client changed any data own grid, all clients notify and refresh theirs grid with refreshDataAndView.

And pqgrid use on some columns pqSelect that condition is range when filtering.

My problem is when refreshDataAndView triggered, pqgrid's  filter is corrupted. Because any custom filter on grid is reloaded.

I do not want the filters to corrupt and want to change only data on view.

Is there a way to ensure that the filters do not get corrupted when the grid is refreshed?

Thanks in advance

2

Bug Report / When filtering with lower "i" cannot find words contains upper "İ" character

« on: November 07, 2017, 06:10:49 pm »

Hi experts,

My data has name surname ex. ALİ İNCİ.

When I filtered that word "ali", i have no result. Grid does not filter upper "İ" from lower "i". How I solve this problem?
In Turkey upper i => "İ" not "I".

Thanks in advance.

3

Bug Report / When colModel dataType is boolean, exportrender:true not run

« on: December 23, 2016, 12:45:21 pm »

Hi everyone,

I use below column code in my colModel, but when I exported grid with exportData method and this render option is true , although column option "exportrender:true" I show in exported excel file on "Avaliability" column 'true or false' not 'Available or Not Available'. Can you help me on my problem? Thanks in advance.

Code: [Select]

{
                    title: "Availability",
                    dataType: "bool",
                    dataIndx: "Availability",
                    editable: false,
                    resizable: true,
                    width: 75,
                    maxWidth: 150,
                    align: "center",
                    filter: { type: 'checkbox', condition: 'equal', subtype: 'triple', listeners: ['click'] },
                    render: function (ui) {
                        return { text: ui.cellData === true ? "Available" : "Not Available" };
                    },
                    exportRender : true
}


4

Help for ParamQuery Grid (free version) / beforeExport example

« on: December 23, 2016, 11:17:25 am »

Hi everyone,

Can you give an example how to modify grid columns,rows or cells (especially cells because i used rendered cells like (input type='text') on colModel and when export option is "render:true", cells become input element on file) when before export event?

Thanks in advance.

5

ParamQuery Pro Evaluation Support / Formula not working set colmodel after grid initialization

« on: November 22, 2016, 10:40:29 am »

Hi everyone,
New colmodel option "formula" not working after grid initialization. When I set colmodel dynamically,  any column's formula option can't load.

Example:
var obj = {colModel:[{title:"#"}]};

$("selector").pqGrid(obj);

Actually  bottom colModel comes from an ajax response;

var colModel = [{title:"1.Column",dataIndx:1, dataType:"integer" }, {title:"2.column", dataIndx:2, dataType:"integer", formula: function(ui) {return ui.rowData[1]*10;}}]

$("selector").pqGrid("option","colModel", colModel); // <= In here formula not load

I have to set colModel like this . Do you have any idea?

Thanks in advance.

6

ParamQuery Pro Evaluation Support / Re: Auto calculate grandSummary after cell editing?

« on: June 14, 2016, 11:23:56 am »

Actually I want to make my grid like this link with remote data
http://paramquery.com/demos/summary
How can I accomplish?

7

ParamQuery Pro Evaluation Support / Auto calculate grandSummary after cell editing?

« on: June 13, 2016, 12:15:35 pm »

Hi everyone,

I use grandSummary on my grid. I have a column, data type is integer, and this is editable. I edit any cell value on this column but grandsummary, type "sum", is not change. How I auto-calculate grandsummary for this row.

And I want  to ask one more question. Grandsummary looks page's summary. Can we use all remote data grandsummary with paging?

Thanks advance.