Messages

1

ParamQuery Pro Evaluation Support / Re: Summary row without using grouping

« on: April 08, 2016, 10:09:07 pm »

Yes it works with virtual scrolling. The issue was that I was setting showBottom to false, that is why it was not showing the summary row.

I am using client side option and calculating the summary data in load event and it is working fine.

2

ParamQuery Pro Evaluation Support / Re: Summary row without using grouping

« on: April 08, 2016, 01:34:35 am »

Please let me know if Manual Summary Row works with virtual scrolling.

Thanks

3

ParamQuery Pro Evaluation Support / Re: Summary row without using grouping

« on: March 31, 2016, 10:20:08 pm »

Thanks it works.

I have another question, the summary row did not show when using virtual scrolling.

4

ParamQuery Pro Evaluation Support / Re: Summary row without using grouping

« on: March 31, 2016, 04:11:12 am »

Thanks, changing srow to object fixed the issue.

It is now showing summary row correctly.

How can I hide the checkboxes and custom icons (used for custom button) in summary row.

Please check my work at:

http://digitallogix.net/pqtest/

5

ParamQuery Pro Evaluation Support / Summary row without using grouping

« on: March 30, 2016, 02:02:13 am »

My grid is using remote data with paging, sorting and filtering. I want to show a summary row without using grouping. I am using the following method in grid complete event:


                var grid1 = pq.grid("div#grid_paging", obj);
               
                function calculateSummary() {
                    var grd = $("div#grid_paging");
                    var data = grd.pqGrid('option', 'dataModel.data');
                    if (data.length > 0)
                    {
                        var totalSum = 0;
                        for (var i = 0, len = data.length; i < len; i++) {
                            var rowData = data;
                            totalSum += parseFloat(rowData["Amount"]);
                        }

                        var cm = grd.pqGrid('option', 'colModel');
                        var srow = [];
                       
                        for (var i = 0; i < cm.length; i++) {
                            var column = cm;
                            if (column.dataIndx == "Amount") {
                                srow.push("Total: " + totalSum);
                            }
                            else {
                                srow.push("");
                            }
                        }

                        var sumRows = [];
                        sumRows.push(srow);
                        grd.pqGrid({ summaryData: sumRows });
                        grid1.refresh();
                    }
                }


It is showing an empty summary row.

6

Bug Report / Remote multiple column sorting not working

« on: March 16, 2016, 06:06:32 am »

Please check the Sorting Remote multiple column demo:

http://paramquery.com/pro/demos/sorting_remote

using the sorting type Multiple Column, it sorts the grid data for 1 column.

It was working in previous version.

7

Bug Report / Hidden column header did not show on Show/Hide Columns

« on: March 16, 2016, 05:58:40 am »

I am using the show/hide columns feature from link:

http://paramquery.com/pro/demos/showhide_columns

In case a column is hidden at load and selecting it using pqselect in grid header, the column header shows the text of next column and the last column header text is empty.

Please check by selecting the column Order ID or Required Date in this demo.

8

ParamQuery Pro Evaluation Support / Re: Using variable in search method

« on: March 11, 2016, 04:49:39 am »

Thanks it works.

A bracket was missing in the last line:

Code: [Select]

var row = {};
row[ coln ] = dvals[ j ];
//now it can be passed to the method:
var rowList = grid1.search({
  row: row,
  first: true
});

9

ParamQuery Pro Evaluation Support / Using variable in search method

« on: March 10, 2016, 05:52:04 pm »

I am using a variable containing column name in search method. The code is:

                        // check for deleted records
                        if (res.deleteList.length > 0) {                           
                            for (i = 0; i < res.deleteList.length; i++) {
                                var objd = res.deleteList;
                                var coln = objd.Name;
                                var dvals = objd.Ids;
                                for (j = 0; j < dvals.length; j++) {
                                    var rowList = grid1.search({ row: { coln : dvals[j] } }, true);
                                    alert(rowList.length);
                                    // remove the row from grid

                                }
                            }
                        }

It is not returning the matched rows. How can I get the row from grid using the variables containing the field name and value?

10

ParamQuery Pro Evaluation Support / Re: Checkbox Selection with Auto Save problem

« on: February 20, 2016, 06:35:21 pm »

Thanks it works.

11

ParamQuery Pro Evaluation Support / Re: Checkbox Selection with Auto Save problem

« on: February 19, 2016, 07:10:36 pm »

Thanks for your suggestion, I have used it and it is not posting data to server now on row selection using checkbox.

I am facing another issue now. I have another checkbox column bound to database field and it is not working with auto save now. The column model is:

{"title":"Status","width":100,"dataIndx":"Status","dataType":"bool","type":"checkbox","hidden":false,"render": function (ui) { var a = 1; } ,"filter":{"type":"checkbox","subtype":"triple","condition":"equal","init": function (ui) { var a = 1; } ,"listeners":[{ 'click': function (evt, ui) { onfilter('Status', $(this), ui.value); } }],"prepend":{}},"editor":{"type":"textbox","init":{}},"editModel":{}}

12

ParamQuery Pro Evaluation Support / Checkbox Selection with Auto Save problem

« on: February 19, 2016, 05:25:50 am »

I am using paramquery grid with asp.net web service as datasource. I have implemented auto save feature from demo:

http://paramquery.com/pro/demos/editing_instant

and also added a checkbox selection column to get ids of selected rows to implement custom features. I have used the following demo:

http://paramquery.com/pro/demos/checkbox_id

The auto save feature is working fine but on check/uncheck of checkbox for row selection it marks the row as dirty and posts the data to server. I have tried by setting editable to false on checkbox column but the selection did not work.

How can I make the grid to avoid auto save on row selection using checkbox?

Here is definition of checkbox selection column:

var colM = [{ dataIndx: 'state1', maxWidth: 30, minWidth: 30, align: 'center', resizable: false, type: 'checkBoxSelection', cls: 'ui-state-default', sortable: false, editor: false, dataType: 'bool', cb: { all: false, header: true, select: true }},
---
];

and here is the toolbar definition:

                    toolbar: {
                        items: [
                            { type: '<strong>' + title + '</strong>' },
                            {
                                type: 'button',
                                label: 'Get Row ID of selected rows',
                                listeners: [{ 'click': function () {
                                    var $grid = $(this).closest('.pq-grid'),
                                        data = $grid.pqGrid('option', 'dataModel.data'),
                                        checked = [];
                                    for (var i = 0, len = data.length; i < len; i++) {
                                        var rowData = data;
                                        if (rowData.state1) {
                                            checked.push(rowData.StudentsID);
                                        }
                                    }
                                    //sort the ids.
                                    checked = checked.sort(function (a, b) { return (a - b); })
                                    alert(checked);
                                }
                                }]
                            },
                            ---
                        ]
                    }


Please check my grid implementation using the following link:

http://digitallogix.net/pqtest/

Thank you