Recent Posts

1

ParamQuery Pro Evaluation Support / Sample project for ASP.Net

« Last post by entwine.llc.wi on July 13, 2018, 10:19:44 pm »

Hello,

I have downloaded the pro trial and am attempting to make it work, however I am running into some issues.  Do you have a sample asp.net project that I could download?  Not just snippets, but an actual project.  I think that would answer a lot of questions for me.

I am on a pretty tight deadline, and in theory your grid is all I want and more, but so far I am not seeing that.

Thank you for your help

2

Bug Report / Re: CSV export "Uncaught TypeError: Cannot read property 'hidden' of undefined"

« Last post by paramquery on July 13, 2018, 03:59:28 pm »

Thanks for reporting issue, it can be reproduced when copy:false is used for csv export, it has been fixed in upcoming version.

As a workaround instead of copy: false, please add hidden: true to columns in beforeExport event and restore them in export event.

3

Help for ParamQuery Pro / Re: Need to double click on a drop down to select a value

« Last post by paramquery on July 13, 2018, 09:44:39 am »

Native browser select list can't be created and opened in a single click because there is no known way to programmatically open it.

It requires use of pqSelect component as editor to do so.

Please include pqSelect files in the document and add this code in column.editor.init callback.

Code: [Select]

      init: function (ui) {
        ui.$cell.find("select").pqSelect(); //first create it.
setTimeout(function(){
ui.$cell.find("select").pqSelect('open');// programmatically open the editor.
})
      },

And yes it also requires editModel.clicksToEdit: 1

Code: [Select]

editModel: {
    clicksToEdit:1,
    ... 
}


4

Bug Report / Re: CSV export "Uncaught TypeError: Cannot read property 'hidden' of undefined"

« Last post by Kenneth on July 13, 2018, 06:27:53 am »

Hi there,

I come across the same issue with the latest version of ParamQuery Pro v5.0.0. It can be easily reproduced when you have column(s) in your grid which have been to set the property "copy" to false.

If you replace the colM object in the demo page with the following, you will see the error:

        var colM = [
            { title: "ShipCountry", width: 120, dataIndx: "ShipCountry",
                filter: {
                    type: 'select',
                    prepend: { '': 'All Countries' },
                    valueIndx: 'ShipCountry',
                    labelIndx: 'ShipCountry',
                    condition: 'equal',
                    listeners: ['change']
                }
            },
            { title: "Customer Name", width: 130, dataIndx: "ContactName" },
       { title: "Test2 Customer Name", width: 130, dataIndx: "ContactName", copy: false },
            { title: "Freight", width: 120, format: '$##,###.00',
                summary: {
                    type: "sum"
                },
                dataType: "float", dataIndx: "Freight"
            },
            { title: "Shipping Via", width: 130, dataIndx: "ShipVia" },
          //{ title: "Shipped Date", width: 100, dataIndx: "ShippedDate", dataType: "date" },
            { title: "Shipping Address", width: 220, dataIndx: "ShipAddress" },
            { title: "Shipping City", width: 130, dataIndx: "ShipCity" }
      ];


When I dig into the source code of the library, I figure out that there may be a potential bug in the method getCsvHeader.

        getCsvHeader: function(hc, hcLen, CM, separator) {
            var self = this,
                header = [],
                csvRows = [],
                column, cell, title;
           
            for (var i = 0; i < hcLen; i++) {
                var row = hc,
                    laidCell = null;
                for (var ci = 0, lenj = row.length; ci < lenj; ci++) {
                      // Bug causing not able to download CSV file

                    column = CM[ci]; <------ this line causing issue;

                    if (column.hidden || column.copy === false) {
                        continue
                    }
                    cell = row[ci];
                    if (i > 0 && cell == hc[i - 1][ci]) {
                        header.push("")
                    } else if (laidCell && ci > 0 && cell == laidCell) {
                        header.push("")
                    } else {
                        title = self.getTitle(cell, ci);
                        title = title ? title.replace(/\"/g, '""') : "";
                        laidCell = cell;
                        header.push('"' + title + '"')
                    }
                }
                csvRows.push(header.join(separator));
                header = []
            }
            return csvRows
        },

I am not sure if this is a bug, if yes, I am looking forward to a fix as we cannot export our data to CSV now.

Thanks!

5

Help for ParamQuery Pro / Need to double click on a drop down to select a value

« Last post by applepqgrid on July 13, 2018, 03:50:25 am »

Hi PQGrid Team,

We have a pro account and we are stuck with below issue.

Issue Description:

We are using PQGrid library to create a data grid which has a drop down inside a cell. We want that on single click the drop down in the grid cell should be editable but drop down is opening on second click. How to avoid multiple clicks to open drop down in edit mode?
We tried below options but none of them worked. Please suggest some option as this is important for our application to have single click dropdown edit.

1. We used the PQGrid clickToEdit property and assigned 1 as value.

2. We also tried fixing with jQuery by binding click event on parent element like below:
$('.superparentclass').on('click','selectdropdowncontainerclass',function() {
$('.pq-editor-outer').find('select').trigger('click');});

We tried with 'change' and 'open' event too but did not work.

6

Help for ParamQuery Grid (free version) / Re: Using Single click to edit a drop down in paramquery grid.

« Last post by paramquery on July 12, 2018, 11:04:33 pm »

Please share your Pro credentials so that your account can be upgraded.

pqSelect can be used as editor if you want to get the dropdown created and open in single click.

7

Help for ParamQuery Grid (free version) / Using Single click to edit a drop down in paramquery grid.

« Last post by pqgridprouser1 on July 12, 2018, 02:44:42 am »

Hi PQGrid Team,

We have a pro account and we are stuck with below issue.

Issue Description:

We are using PQGrid library to create a data grid which has a drop down inside a cell. We want that on single click the drop down in the grid cell should be editable but drop down is opening on second click. How to avoid multiple clicks to open drop down in edit mode?
We tried below options but none of them worked. Please suggest some option as this is important for our application to have single click dropdown edit.

1. We used the PQGrid clickToEdit property and assigned 1 as value.

2. We also tried fixing with jQuery by binding click event on parent element like below:
$('.superparentclass').on('click','selectdropdowncontainerclass',function() {
$('.pq-editor-outer').find('select').trigger('click');});

We tried with 'change' and 'open' event too but did not work.

8

Help for ParamQuery Pro / Re: groupmodel

« Last post by paramquery on July 11, 2018, 11:42:33 pm »

Sorry, this is not supported.

9

Help for ParamQuery Pro / Re: groupmodel

« Last post by chirag on July 11, 2018, 06:21:28 pm »

Find attached screenshot. I want group by this rows and want collapse it but at the same time it should display 1st row when collase.

10

Help for ParamQuery Pro / Re: Group summary that is a formula

« Last post by TeeJT on July 11, 2018, 03:18:56 pm »

Thank you very much! This was exactly what I needed.