Recent Posts

1

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

« Last post by paramvir on September 29, 2023, 07:55:56 pm »

Duplicate columns can't be used in the colModel.

Every column is supposed to have unique dataIndx.

2

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

« Last post by vijay@spinetechnologies 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.

3

Help for ParamQuery Grid (free version) / Re: Refresh row in nested grid

« Last post by Pisga on September 28, 2023, 03:04:38 pm »

Thank you very much, the solution works OK !

4

Bug Report / bug in treegrid

« Last post by hyh888 on September 27, 2023, 06:00:48 am »

When the pid of the top root node in treegrid is 0( for the database in my company required that pid field couldn't be null.), the treegrid couldn't be show out.
When I tried modify the response data which come from server, it wil make a lot of trouble in select box in treegrid.
Is there any way to fix the bug?

5

ParamQuery Pro Evaluation Support / MOVED: When rowSpanHead mode is set to true, sorting functionality is not working

« Last post by paramvir on September 26, 2023, 07:50:09 am »

This topic has been moved to Help for ParamQuery Pro.

https://paramquery.com/forum/index.php?topic=4710.0

6

Help for ParamQuery Pro / Re: When rowSpanHead mode is set to true, sorting functionality is not working

« Last post by paramvir on September 26, 2023, 07:49:50 am »

It would be fixed in upcoming version.

This patch can be used for now to fix it

Code: [Select]

pq.cRenderHead.prototype.onHeaderCellClick=function(e,t,s){e=e||{};var l=this.that,i=l.options,r=i.sortModel,a=i.selectionModel,o=$(s.target),d=e.dataIndx;if(!1!==l._trigger("headerCellClick",s,{column:e,colIndx:t,dataIndx:d})&&-1!=t&&!o.closest(".pq-grid-header-search-row")[0]){if(a.column&&a.type&&!o.hasClass("pq-title-span")&&!o.hasClass("ui-icon")){var n=l.getFirstVisibleRIP(),c={c1:t,firstC:t,firstR:n},p=l.iSelection,u=p.address(),C=u.length;if(pq.isCtrl(s))p.add(c);else{if(s.shiftKey){if(C&&"column"==u[C-1].type){var f=u[C-1];f.c1=f.firstC,f.c2=t,f.r1=f.r2=f.type=f.cc=void 0}c=u}l.Range(c,!1).select()}null!=(n=l.getFirstVisibleRIP(!0))&&(l.focus({rowIndxPage:n,colIndx:t}),l._trigger("mousePQUp"))}else(r.wholeCell||o.hasClass("pq-title-span"))&&l.isSortable(e)&&l.sort({sorter:[{dataIndx:d,sortIndx:e.sortIndx}],addon:!0,skipCustomSort:pq.isCtrl(s),tempMultiple:r.multiKey&&s[r.multiKey],evt:s})}};


7

Help for ParamQuery Pro / Re: tree grid and dragg and drop

« Last post by paramvir on September 25, 2023, 10:06:58 pm »

There is no option to make the whole region in row draggable with mouse.

Rows can be dragged only via an icon displayed in number cell or any cell with help of dragModel.diDrag option

https://paramquery.com/pro/api#option-dragModel

8

Help for ParamQuery Pro / Re: tree grid and dragg and drop

« Last post by hirehop on September 25, 2023, 06:35:18 pm »

Thank you very much its work nice but i wanted to do drag and drop with selected row
becuse right now its dragg and drop with left column 1st column

i wanted to click and hold selected row and then drag and drop

9

Help for ParamQuery Pro / When rowSpanHead mode is set to true, sorting functionality is not working

« Last post by YONGHOO KIM on September 25, 2023, 10:26:50 am »

Hi !
When the header row in a grid consists of multiple rows, and you set the rowSpanHead mode to true, it's expected behavior that only the columns in the final row of the header will be sortable.
How can I enable sorting functionality for columns other than the final row's column ?

10

Help for ParamQuery Pro / Re: tree grid and dragg and drop

« Last post by hirehop on September 21, 2023, 09:07:48 pm »

Thank you very much