Messages

1

Help for ParamQuery Grid (free version) / Paste Column in the Grid Add new Rows

« on: October 08, 2024, 07:05:29 pm »

Hello Paramvir

I am using paramquery with column paste functionality.

Suppose, the target grid contains 5 Rows only. Whenever I tried to paste more than 5 vertical cells, additional rows were inserted in the grid.
I don't want such behavior. I want the grid to only accept the first 5 cell values and not generate new rows

2

Help for ParamQuery Grid (free version) / Filter the Records on Server side with Server side pagination.

« on: August 19, 2024, 05:01:47 pm »

Hi Paramvir,

We are using PQ Grid (v9.0.1)  with Server Side Pagination and Server Side Filter Options.

Suppose, I Move to the Second page and try to filter the data, Internally I get the Current Page index i.e. 1

In this case, When the filtration is applied, the Page index should reset to 0.

3

Help for ParamQuery Grid (free version) / After Data Filtering, Pagination and Record Count do not change

« on: July 23, 2024, 11:59:17 am »

Hi Team,

we are using ParamQuery Pro v9.0.1, we are facing the following issue.

After Filtering data (toolbar local Search), the Pagination and Record count do not change.

we have kept filterModel.hideRows = true
if we keep filterModel.hideRows = false then it works properly.

please guide us.

4

Help for ParamQuery Select / Re: Maintain the selection sequence in multi select dropdown

« on: June 21, 2024, 04:53:34 pm »

Hi Paramvir,

Thank you for the response.

From the change function, I can get the values. However, I can not set the values to the dropdown.

In my case, I am getting the values from the dropdown and storing them in the DB. When the user revisits the same page I want to set the data to the dropdown with its given sequence.

So is there any function, or event where I can set the values to the dropdown with the proper sequence?

5

Help for ParamQuery Select / Maintain the selection sequence in multi select dropdown

« on: June 21, 2024, 11:54:10 am »

Hi Paramveer,

We have a requirement to maintain the user selection sequence.

For example, if the dropdown has Sun, Mon, Tue, Wed, Thu, Fri, and Sat options and the user opts for the values on Wed, Sat, and Sun,

As per the dropdown behavior, whenever I fetch the values I receive values as Sun, Wed, Sat. The same happens while setting values back to the dropdown.

Is it possible to maintain the sequence?

6

Help for ParamQuery Select / Re: Search functionality not working in mobile

« on: April 17, 2024, 06:10:10 pm »

Hi Paramveer,

I tried the proposed solution and it worked for me.

Thank You

7

Help for ParamQuery Select / Search functionality not working in mobile

« on: April 03, 2024, 01:16:52 pm »

I have used pqselect plugin in my project. I found that the search is not supported on mobile. When I try to search, every time I touch the search text box, the mobile keyboard appears, and the select box disappears as soon as the keyboard appears.

Kindly help me in this matter

8

Help for ParamQuery Pro / Re: PqGrid FillHandle Makes Page Unresponsive

« on: January 23, 2024, 06:49:07 pm »

Can we disable double-click on the Plus Icon to fill data?

9

Help for ParamQuery Pro / Re: PqGrid FillHandle Makes Page Unresponsive

« on: January 19, 2024, 04:56:12 pm »

We have tried below sample code to generate the scenario.
When we click the Plus icon on the Country column dropdown to apply all rows then same issue occurs.


    $(function () {       
        var colModel = [
            { title: "Customer ID", dataIndx: "customerid", width: 120 },
            {
                title: "Country", width: "120", dataIndx: "country",
                style: { 'background-color': 'beige' },
                cls: 'pq-drop-icon',
                editor: {
                    type: 'select',
                    options: function(){
                   return ['Green', 'Yellow', 'Blue'];
                    }
                }
            },
            { title: "Company Name", width: 180, dataIndx: "companyname" },
          { title: "Address", width: "170", dataIndx: "address" }
      ];
       
      var dataModel = function(){
      
         var data = [];
         
         for(i=0; i<=200000; i++){
            data.push({'customerid':`C00${i}`, 'country':'', 'companyname':`test ${i}`,'address':`test location ${i}`});
         }         
         return data;
      }
      
      
        var newObj = {
            width: 'auto',
            editModel: { clicksToEdit: 1, addDisableCls: true },
         pageModel: { type: "local", rPP: 20, strRpp: "{0}", strDisplay: "{0} to {1} of {2}" },       
            dataModel: { data: dataModel() },
            showTitle: false,
            showBottom: false,
            colModel: colModel,           
         fillHandle: 'all',
            copyModel: { header: true },           
            cellSave: function (evt, ui) {
                //refresh the row to update the read only cells.               
                this.refreshRow({rowIndx: ui.rowIndx});
            },
            scrollModel: { autoFit: true },
            title: "Contact Details"
        };
        $("#grid_readonly").pqGrid(newObj);
    });

10

Help for ParamQuery Pro / Re: How to use DateTime Picker in PqGrid Cell

« on: January 19, 2024, 03:32:27 pm »

we use below DateTime Picker plugins

1. Flatpickr
https://flatpickr.js.org/examples/

2. Bootstrap
https://tarruda.github.io/bootstrap-datetimepicker/

11

Help for ParamQuery Pro / Re: Columns overlaps in case of the Animation mode is on

« on: January 18, 2024, 12:44:46 pm »

Hi Paramvir,

Thanks for your quick response. I tried your proposed solution and it works for me.

Once again thank you

12

Help for ParamQuery Pro / PqGrid FillHandle Makes Page Unresponsive

« on: January 18, 2024, 12:29:16 pm »

Dear Team,

We are using PqGrid Version 9.0.1,
we have enabled filehandle: all option. When we double click to apply data to all records then the page becomes unresponsive and takes a longer time to apply data for all records.


Note*
No. of records displayed in the grid is 21000,
we have enabled virtual rendering (virtualX: true, virtualY: true)
Find the attached screenshot for your reference.

Kindly suggest how to handle above scenario.

13

Help for ParamQuery Pro / How to use DateTime Picker in PqGrid Cell

« on: January 18, 2024, 12:02:59 pm »

Dear Team,

We are using PqGrid version 9.0.1
We are not able to find an appropriate example for the bootstrap DateTime Picker Column (Date and time).
Kindly Help.

14

Help for ParamQuery Pro / Re: Columns overlaps in case of the Animation mode is on

« on: January 18, 2024, 10:59:56 am »

Hi Paramvir,

Finally, I found the actual reason for the column overlaps. As per the requirement, My grid has approximately 50-100 columns.
So whenever the grid loads, the columns are in shrink mode like in example 1.

To expand the columns, I call the flex method inside the scroll event. So whenever the user scrolls the grid the next columns are expanded.
But in some cases, when the user scrolls the grid quickly the columns overlap each other. Like example 2.

For a better understanding, kindly refer to the attached file.

15

Help for ParamQuery Pro / Re: Columns overlaps in case of the Animation mode is on

« on: September 29, 2023, 07:26:33 pm »

Hi Paramvir,

Please find the attached Code,

$(function () {
        var columns = [
            { title: "Order ID", dataIndx: "OrderID" },
            { title: "Customer Name", dataIndx: "CustomerName" },
            { title: "Product Name", dataIndx: "ProductName" },
            { title: "Unit Price", dataIndx: "UnitPrice", dataType: 'float', format: '$#,###.00' },
            { title: "Quantity", dataIndx: "Quantity", dataType: 'integer' },
          { title: "Order Date", dataIndx: "OrderDate" },
          { title: "Required Date", dataIndx: "RequiredDate" },
          { title: "Shipped Date", dataIndx: "ShippedDate" },
            { title: "ShipCountry", dataIndx: "ShipCountry" },
            { title: "Freight", align: "right", dataIndx: "Freight" },
            { title: "Shipping Name", dataIndx: "ShipName" },
            { title: "Shipping Address", dataIndx: "ShipAddress" },
            { title: "Shipping City", dataIndx: "ShipCity" },
            { title: "Shipping Region", dataIndx: "ShipRegion" },
            { title: "Shipping Postal Code", dataIndx: "ShipPostalCode", minWidth: 150 },
         { title: "Order ID", dataIndx: "OrderID" },
            { title: "Customer Name", dataIndx: "CustomerName" },
            { title: "Product Name", dataIndx: "ProductName" },
            { title: "Unit Price", dataIndx: "UnitPrice", dataType: 'float', format: '$#,###.00' },
            { title: "Quantity", dataIndx: "Quantity", dataType: 'integer' },
          { title: "Order Date", dataIndx: "OrderDate" },
          { title: "Required Date", dataIndx: "RequiredDate" },
          { title: "Shipped Date", dataIndx: "ShippedDate" },
            { title: "ShipCountry", dataIndx: "ShipCountry" },
            { title: "Freight", align: "right", dataIndx: "Freight" },
            { title: "Shipping Name", dataIndx: "ShipName" },
            { title: "Shipping Address", dataIndx: "ShipAddress" },
            { title: "Shipping City", dataIndx: "ShipCity" },
            { title: "Shipping Region", dataIndx: "ShipRegion" },
            { title: "Shipping Postal Code", dataIndx: "ShipPostalCode", minWidth: 150 },
         
      ];
        var dataModel = {
            location: "remote",
            dataType: "JSON",
            method: "GET",
            url: "/Content/invoice.json"
        }

        $("#dndgrid").pqGrid({
            dataModel: dataModel,
           
            pageModel: { type: 'local', rPP: 20, rPPOptions: [1, 10, 20, 30, 40, 50, 100] },
            colModel: columns,
            title: "Shipping Orders"  ,   
         flex:{on:true},
         animModel:  { on: true, duration: 400 },
         //resizable: true,
         virtualX: true, virtualY: true,
         
         scroll: function( event, ui ) {this.flex()}
        });       
      
    });

Copy and paste the above code in the https://paramquery.com/pro/demos/dnd_grid example
Then, Edit and Run the code.
Then simply scroll the grid horizontally. The case will reproduce.