Messages

1

Bug Report / Re: New row comit and pq_detail column

« on: March 21, 2025, 11:46:01 am »

I don't understand why you have added pq_detail in the colModel. Can you please clarify?

2

Help for ParamQuery Pro / Re: Using loadState in grouped fields

« on: March 20, 2025, 06:10:22 pm »

Thanks for mentioning the steps.

Please add this patch to fix the error.

Code: [Select]

jQuery.paramquery.pqGrid.prototype.loadState=function(e){e=e||{};var t,o=this,r=$.widget.extend,d=e.state||o.getState();if(!d)return!1;pq.isStr(d)&&(d=JSON.parse(d));var a,l=d.colModel,i="pid"+Math.random(),n={},s={},p={},h=o.options,M=e=>e.dataIndx||e.id||e.title,c=(delete(a=h.stateColKeys).colModel,delete a.dataIndx,a),f=h.colModel,u=(e,t,o,r)=>{var d=o[t]={};e.forEach(((e,a)=>{var l=M(e);e.parentId=t,r[l]=e,d[l]=a,e.colModel&&u(e.colModel,l,o,r)}))};for(var g in u(l,i,s,n),p[i]={colModel:f},u(f,i,{},p),p){var v=n[g],N=p[g];if(v){if(N.parentId!=v.parentId){var w=p[N.parentId],I=p[v.parentId];I&&(w.colModel.splice(w.colModel.indexOf(N),1),I.colModel.push(N))}o._saveState(v,N,c)}}return function e(t,o){var r=s[o];r&&t.sort((function(e,t){return r[M(e)]-r[M(t)]})),t.forEach((t=>{delete t.parentId;var o=t.colModel||[];o.length&&e(o,M(t))}))}(f,i),o.iCols.init(),r(h.sortModel,d.sortModel),r(h.pageModel,d.pageModel),o.Group().option(d.groupModel,!1),o.Tree().option(d.treeModel,!1),t={freezeRows:d.freezeRows,freezeCols:d.freezeCols},isNaN(1*h.height)||isNaN(1*d.height)||(t.height=d.height),isNaN(1*h.width)||isNaN(1*d.width)||(t.width=d.width),o.option(t),!1!==e.refresh&&o.refreshDataAndView(),!0};


3

Help for ParamQuery Pro / Re: Pivot Grid - Default Aggregate function for Columns

« on: March 20, 2025, 12:37:59 pm »

I understand that's incorrect behavior of pqgrid pivot to use default aggregate as "sum" for all columns. It would be fixed in upcoming version.

Meanwhile please use this patch to fix it

Code: [Select]

jQuery.paramquery.cToolPanel.prototype.getObj=function(t){var a={},e=this.that;return t.find(".pq-pivot-col").each((function(t,r){var u=r.dataset.di,o=e.getColumn({dataIndx:u}),n=r.getAttribute("type")||o.summaryDefault||e.iGroup.getAggOptions(o.dataType)[0];o.summaryDefault=a[u]=n})),a};

you may remove the custom code in pivotCM event related to it.

4

ParamQuery Pro Evaluation Support / Re: Upgrading from free version to evaluation copy

« on: March 20, 2025, 12:29:41 pm »

you have to make few code changes in order to make it work for evaluation copy.

Please refer to the upgrade guides https://paramquery.com/pro/upgrade/Index to find out the required changes in your code.

5

Help for ParamQuery Pro / Re: Clear Text Icon in Header Filters

« on: March 19, 2025, 06:47:41 pm »

Please set filterModel.hideClearIcon to true to disable it.

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

6

Help for ParamQuery Pro / Re: "Horizontal scrollbar" not getting displayed in PQ grid if column's having more

« on: March 18, 2025, 05:41:24 pm »

It has nothing to do with jQuery/ jQueryUI but this is how scrollModel.autoFit works for now, the horizontal scrollbar is never displayed with this option.

The feature to display a horizontal scrollbar when column widths reach their minimum and no space remains for scrollModel.autoFit has been reintroduced in the upcoming version.

7

Suggest new features / Re: Option to allow horizontal scroll bar when needed when scrollModel.autofit=true

« on: March 18, 2025, 05:32:02 pm »

This feature was available in older versions of pqgrid but lost when we migrated to smooth native scrolling in v5.

It has been reintroduced in upcoming version, thanks for your feedback.

8

Help for ParamQuery Pro / Re: "Loading" box not displayed for Nesting of grids with lazy loading

« on: March 14, 2025, 08:48:37 am »

Thanks for reporting the issue. It's caused by change in functioning of jquery show method in 3.x, it only works if the element is attached to DOM.

There are 2 alternate ways to fix it.

1) Use this patch:

Code: [Select]

$.paramquery.pqGrid.prototype.showLoading = function () {
  this.loading = true
  this.$loading[0].style.display = "block"
}

or
2. Change the detailModel.init method

Code: [Select]

        init: function (ui) {
          var rowData = ui.rowData,
            detailobj = gridDetailModel(this, rowData), //get a copy of gridDetailModel
            $grid = $("<div/>") //.pqGrid(detailobj) //init the detail grid.

          setTimeout( _ => $grid.pqGrid(detailobj) );

          return $grid
        },

jsfiddle: https://jsfiddle.net/rpx0dkef/1/

9

Help for ParamQuery Pro / Re: "Horizontal scrollbar" not getting displayed in PQ grid if column's having more

« on: March 13, 2025, 06:24:18 pm »

Please ensure to upgrade jqueryUI also to one of the latest versions compatible with jquery 3.7.1.

Please remove the scrollModel.autoFit:  true option to display the horizontal scrollbar when required.

10

Help for ParamQuery Pro / Re: Using loadState in grouped fields

« on: March 11, 2025, 03:19:33 pm »

Is there any particular sequence of events which cause the error.

I've clicked the saveState and loadState buttons a couple of times while continuously changing various grid options, such as the group-by column, order of columns, page number, etc., but I haven't been able to reproduce the error so far.

11

Help for ParamQuery Pro / Re: Treegrid pagination

« on: March 07, 2025, 07:08:27 am »

It's mentioned on this example: https://paramquery.com/pro/demos/treegrid

Paging:

Treegrid is not compatible with paging.

12

Help for ParamQuery Pro / Re: "Loading" box not displayed for Nesting of grids with lazy loading

« on: March 06, 2025, 11:15:14 pm »

I was hoping to see the live issue on jsfiddle. Since your jsfiddle is not functioning, I can only make a guess. There are a couple of showLoading and hideLoading calls in your code. Please comment them one by one and see how it goes.

13

Help for ParamQuery Pro / Re: "Loading" box not displayed for Nesting of grids with lazy loading

« on: March 05, 2025, 04:05:06 pm »

Loading box is displaying fine in v9.1.1

https://paramquery.com/pro/demos91/nesting

No idea why it's not working for you. I can look into it if you have a jsfiddle to share.

14

Help for ParamQuery Pro / Re: Show tabular data in cell hover over

« on: March 05, 2025, 03:45:07 pm »

Rich html content can be displayed in the cell tooltips by using attr property in column.render callback.

Code: [Select]

render: function( ui ){
   return {
attr: {
title: "<b>Rich</b> <i>Text<i>!"
}
   }
}

and creating pqTooltip in the create callback in main grid options.

Code: [Select]

create: function (evt, ui) {               
        this.widget().pqTooltip();
}


15

ParamQuery Pro Evaluation Support / Re: Upgrading from 5.3.0pro to the Latest Version: Concerns about Backward Compatibi

« on: February 19, 2025, 08:23:35 am »

The breaking changes between versions are documented in the upgrade guides, so you need to refer to the upgrade guides between v5.2.0 and latest version.