Messages

1

Help for ParamQuery Grid (free version) / Re: Filter mode "AND" and "OR" not working at same time

« on: October 19, 2016, 12:27:01 pm »

Thank you for your reply.

Is there any way to get my intended result using local filtering?

2

Help for ParamQuery Grid (free version) / Re: Filter mode "AND" and "OR" not working at same time

« on: October 18, 2016, 07:59:05 pm »

Sorry, its not working, the result I got, I am explaining bellow -
Case 1: When I am writing the following code-
                       $( "#grid_documents" ).pqGrid( "option", "filterModel.mode", "OR" );
                       $("#grid_documents").pqGrid( "filter", {
                        oper: 'add',                       
                        data: [                         
                            { dataIndx: 'Detail', condition: 'range', value: ["Tom Brook_52", "Templeton Robinson"]},
                            { dataIndx: 'Owner', condition: 'range', value: ["Tom Brook_52", "Templeton Robinson"]},
                            { dataIndx: 'Manager', condition: 'range', value: ["Tom Brook_52", "Templeton Robinson"]}
                        ]
                    });
           I am getting the result shown in picture "case1".

Cae 2: When I am writing
                      $( "#grid_documents" ).pqGrid( "option", "filterModel.mode", "OR" );
                      $("#grid_documents").pqGrid( "filter", {
                        oper: 'add',                       
                        data: [                         
                            { dataIndx: 'Detail', condition: 'range', value: ["Tom Brook_52", "Templeton Robinson"]},
                            { dataIndx: 'Owner', condition: 'range', value: ["Tom Brook_52", "Templeton Robinson"]},
                            { dataIndx: 'Manager', condition: 'range', value: ["Tom Brook_52", "Templeton Robinson"]}
                        ]
                    });
                    $( "#grid_documents" ).pqGrid( "option", "filterModel.mode", "AND" );
                    $("#grid_documents").pqGrid( "filter", {
                        oper: 'add',                     
                        data: [
                            { dataIndx: 'DocType', condition: 'regexp', value: "Property Image"}
                        ]
                    });
             I am getting the result shown in picture "case2".

My intended result shown in picture "DocumentFilter"

3

Help for ParamQuery Grid (free version) / Filter mode "AND" and "OR" not working at same time

« on: October 18, 2016, 01:05:32 pm »

I want the result based on filter mode "OR" according to input in autocomplete i.e in autocomplete if I select Owner= X as well a Manager=Y then grid will show all records for which Owner= X plus all records for which Manager = Y. For example, if there are 2 record for Owner=X and 3 records for Manager=Y then grid will show all 5 records.

Now, If I select Document Type=ABC with above autocomplete input then I want the result where Owner=X and Manager=Y and Document Type=ABC (i.e I want result based on filter mode "AND").

For this situation I write the following code-

                   $( "#grid_documents" ).pqGrid( "option", "filterModel", { on: true, mode : "OR" } );               
                    $("#grid_documents").pqGrid( "filter", {
                        oper: 'add',                       
                        data: [                         
                            { dataIndx: 'Detail', condition: 'range', value: ["X", "Y"]}
                        ]
                    });
                    $("#grid_documents").pqGrid( "filter", {
                        oper: 'add',                       
                        data: [                         
                            { dataIndx: 'Owner', condition: 'range', value: ["X", "Y"]}
                        ]
                    });
                    $("#grid_documents").pqGrid( "filter", {
                        oper: 'add',                       
                        data: [                         
                            { dataIndx: 'Manager', condition: 'range', value: ["X", "Y"]}

                        ]
                    });   

 
               $( "#grid_documents" ).pqGrid( "option", "filterModel", { on: true, mode : "AND" } );                       
                    $("#grid_documents").pqGrid( "filter", {
                        oper: 'add',                     
                        data: [
                            { dataIndx: 'DocType', condition: 'regexp', value: "ABC"}
                        ]
                    });

Here I attached my filter UI, I think it may help to understand the stated problem.

Thank You.

4

Help for ParamQuery Grid (free version) / Paramquery Nested Grid

« on: July 05, 2016, 01:31:06 pm »

Hi

I tried paramquery nested grids with http://paramquery.com/demos . But I want to know the remote code in ASP.NET MVCPHP or  for
 url: "/pro/orders/get"
and "/pro/orderdetails/get?orderId=" + orderID;

or instead of remote using local example

Please help

5

Help for ParamQuery Grid (free version) / local filter for multiple column

« on: April 26, 2016, 03:53:41 pm »

Hi
I need multiple filter for local on a button click not in header . so I write this code for single column on a button click and it is working
var f1=['4004','4003'];
$("#propertygrid").pqGrid( "filter", {
                            oper: 'replace',
                            data: [
                                  { dataIndx: 'ID', condition: 'range', value: f1 }
                            ]
                        });
but when I want to apply this for multiple column then the following code is not working
var f2=['test4_address','Souvik_share_property'];
var f1=['4004','4003'];
$("#propertygrid").pqGrid( "filter", {
                            oper: 'replace',
             on: true,
                            mode : "OR",
                            data: [
                               
                                { dataIndx: 'ID', condition: 'range', value: f1 },

                               { dataIndx: 'Address', condition: 'range', value: f2},
                            ]
                        });

Please help me.

6

Help for ParamQuery Grid (free version) / How I filter my grid on a button click using local filtering

« on: February 10, 2016, 11:30:31 am »

I have grid with local head filtering but I need a custom local filtering of a date column on a button click using between operator and also reset the filtering on a reset button click.

7

Help for ParamQuery Grid (free version) / how I back from full screen mode after fullscreen grid

« on: January 27, 2016, 07:20:47 pm »

There is a feature of the grids that expands the grid to the whole page. It is nice, but I don’t know how to get it to return to the normal size.