Messages

1

Help for ParamQuery Grid (free version) / Click event of Header checkbox

« on: September 09, 2016, 08:45:40 pm »

Hi,

I have a paramquery grid with pagination, a check box column and filters for the columns. I want to be able to catch the  click event for all the check boxes including the header checkbox. I was able to get the click event for all the checkboxes by adding cellClick: function(evt, ui){} for the grid and finding the right cell but this does not catch the header checkbox.
I have tried cellClick, rowSelect, rowUnselect, onClick and onchange, but none of them give me the result I am looking for.

I would greatly appreciate if someone can suggest how to get the header checkbox click event, also suggest if there is a better way to get the checkbox click event as well.

Thank you.

2

Help for ParamQuery Pro / Re: Multi word filtering on same column

« on: May 23, 2016, 09:08:55 pm »

I see this example for dropdown filter. How do I apply range on textbox filter?

3

Help for ParamQuery Pro / Multi word filtering on same column

« on: May 20, 2016, 10:50:32 pm »

Hello,
With 2.x, do you have a sample of how to do multi word local filtering in same column.

Thanks

4

Help for ParamQuery Pro / Re: paramquery grid date filter with null value

« on: April 13, 2016, 01:12:37 am »

I found the issue. I was using date.js which was causing all the issues.
Thanks for your help.

5

Help for ParamQuery Pro / Re: paramquery grid date filter with null value

« on: April 08, 2016, 07:36:26 pm »

I tried with "" empty date but still doesn't work for me. Your example work but not my code. Seems like it is getting converted to date "12/31/1969". Not sure why. We are using 2.2 version.

filterModel: { header: true, type: 'local' }

6

Help for ParamQuery Pro / paramquery grid date filter with null value

« on: April 07, 2016, 11:17:10 pm »

Hi,
We have date filter on the grid as -
{ title: "Next Cal", width: 165, dataType: "date", dataIndx: "NEXT_CAL",
                       render: function (ui) {if (ui.cellData == null) return null; else return $.datepicker.formatDate('mm/dd/yy', new Date(Date.parseExact(ui.cellData,'d-MMM-yyyy')));},
                        filter: { type: 'textbox', condition: "between", init: pqDatePicker, listeners: ['change']  }
                   },


This field allows null so we have few records with empty/null date.
When we filter with end date, the row with null date shows up too. It should not show up. Please help.

7

Help for ParamQuery Pro / Filter date issue on IE11

« on: December 21, 2015, 09:44:44 pm »

you demo for date filtering on IE11 is not working correctly.
http://paramquery.com/pro/demos/filter_date

The date picker keeps on popping up even after selecting date.
Please advise.

8

Help for ParamQuery Pro / Dynamic column width not getting set

« on: December 21, 2015, 09:29:35 pm »

We are creating dynamic columns for the grid based on user selection.
The problem is with the width of the dynamic columns. It is not getting set and all the dynamic columns are appended to the right side , width being very small. Please help.
grid configurations -
width: "auto",
 scrollModel: {
                    autoFit: true
                },

This is the code which adds the columns to the grid.
var j = 2;//number of static field on grid
for (var i = 0, len = data.length; i < len; i++) {
  var rowData = data;
          
   colM.push( { title: rowData["DisplayName"] + "    "+"<input type='checkbox' class='showHideInsColumn'    id='"+j+"' /> ", dataType: "float", minWidth: '30%', maxWidth:'50%', align: "center",colModel: [
                                    { title: "Data", align: "center", dataIndx: rowData["DisplayName"], dataType: "string" },
                                    { title: "EIN", align: "center", dataIndx: rowData["DisplayName"]+'_EIN', dataType: "string", hidden:true },
                                    { title: "Who", align: "center", dataIndx: rowData["DisplayName"]+'_Who', dataType: "string", hidden:true },
                                   { title: "Date", align: "center", dataIndx: rowData["DisplayName"]+'_Date', dataType: "string", hidden:true }
                                  ]
                       } );
            j=j+1;
       }

9

Help for ParamQuery Pro / Re: checkbox selection with rendering

« on: December 18, 2015, 09:45:22 pm »

perfectly what I was looking for. Great support. Thanks

10

Help for ParamQuery Pro / Re: checkbox selection with rendering

« on: December 18, 2015, 12:21:03 am »

Another question for header checkbox -
When user comes back to the grid and if he had selected all the rows previously using header checkbox, we want to show it back to user.
This is how we do -
$grid.one("pqGrid:load", function (evt, ui) {
 if(areAllSamplesSelected) {
            $('#grid_sample .pq-grid-title-row input:checkbox')[0].checked = true;
 }
}
This does not retain the checkbox checked.
We have
cb: { all: true, header: true, select: true },

What am I missing here?

11

Help for ParamQuery Pro / Re: checkbox selection with rendering

« on: December 17, 2015, 01:41:29 am »

Thanks that helped.

12

Help for ParamQuery Pro / Re: pqgridload not getting called after upgrade to 3.2

« on: December 15, 2015, 10:20:41 pm »

Great help buddy. That worked. Thank you so much!!!

13

Help for ParamQuery Pro / Re: pqgridload not getting called after upgrade to 3.2

« on: December 15, 2015, 10:08:15 pm »

ok I changed accordingly
$("#grid_procedure").on("pqGrid:load", function (evt, ui) {
               if (typeof filterObject !== 'undefined' && filterObject.length > 0) {
                  $("#grid_procedure").pqGrid( "filter", {
                        oper: 'add',
                        data: filterObject
                    });
                  var grid = $grid.pqGrid("getInstance").grid;
                  grid.refreshView();
               }
            });

Here
$("#grid_procedure").pqGrid( "filter" -> is getting called recursively. Now can I not use the filter in the load method for the same grid?

14

Help for ParamQuery Pro / Re: checkbox selection with rendering

« on: December 15, 2015, 09:19:01 pm »

Thanks for the quick reply. Paging is local paging in my case since I do not intend to make a round trip to server on page change.
What I did previously was when checkbox is rendered based on the saved value, I used to check/uncheck it accordingly. It worked fine with v2.0. Now since the rendering serves different purpose, I need an alternative.

15

Help for ParamQuery Pro / pqgridload not getting called after upgrade to 3.2

« on: December 15, 2015, 02:10:04 am »

Below is the piece of code which we used to repopulate the filter which user has applied earlier. This is not getting called. Can you please let us know the changes.

//for showing saved filters
            $grid.one("pqgridload", function (evt, ui) {
               if (typeof filterObject !== 'undefined' && filterObject.length > 0) {
                  $("#grid_procedure").pqGrid( "filter", {
                        oper: 'add',
                        data: filterObject
                       
                        
                    });
                  var grid = $grid.pqGrid("getInstance").grid;
                  grid.refreshView();
               }
            });