Recent Posts

61

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

« Last post by Jit on March 20, 2025, 11:53:28 am »

Hello there,
I have been implementing pqGrid free version, to my project.
Free version has been great, but I want to checkout pro version and if it suits my use case then hopefully transition to paid version.

I want to know the required steps , and things to take care before shifting to paid version.

I tried migrating it by following the tutorial, but all of my existing functionality are not working:

What I tried:
Replaced the free version js and css file to paid version (Did no code changes) :
- pqgrid.min.css
- pqgrid.ui.min.css
- pqgrid.min.js
- /localize/pq-localize-en.js

Please let me know if any extra steps are required.
Thank you

62

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

« Last post by mlipham on March 20, 2025, 08:50:33 am »

I have a (Pivot) grid with several data types in it – dates, string, and some numbers.


I have been tasked with fixing the behavior where if one drags a date field into the “Aggregates” box (lower right), it automatically assumes “Sum()”.

It can be clicked and changed to a proper aggregate function, like count() or Min/Max, but the default is sum(). As you know, this means the values in the grid appear as NaN or other weird formats.
 

One suggestion I saw was to add summary  type=null to each column definition, which didn't seem to help.


As an alternative, I have some custom .js code that seems to fit the bill – almost. The code below will intercept the ‘drag-in’ and changes it to count() by default – yay! – but the data in the grid still says NaN, as though it ran it as sum(). This leads me to believe I probably need to refresh the grid to register the new change.


So even if I add the refresh, I can’t help wondering – is there a simpler way that I am overlooking? Am I going about this the hard way? Is there a much simpler approach or configuration to achieve the same?


Below please find my code scratchings: (Yes, I also need to add code to handle strings)


( event: pivotCM:  )

Code: [Select]

function (evt, ui) {
   
    //previous code to concat field value to column header

    ...

    //Code to change from sum to count

    ui.CM.forEach(col => {

        if (col.dataType == "date" && col.summary.type == "sum") {

            col.summary.format = "";

            col.summary.type = "count";

        }

        if (col.dataType === "date") {

            if (col.summary.type === "count") {

                col.summary.format = "0";               

            } else {

                col.summary.format = "mm/dd/yy hh:mm:ss";

            }

        }

    });

}


Thanks!

63

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

« Last post by paramvir on March 19, 2025, 06:47:41 pm »

Please set filterModel.hideClearIcon to true to disable it.

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

64

Help for ParamQuery Pro / Clear Text Icon in Header Filters

« Last post by queensgambit9 on March 19, 2025, 05:48:09 pm »

Is the feature "Clear Text Icon in Header Filters" enabled as default in v10.1.0?
How do you disable it?

65

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

« Last post by paramvir 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.

66

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

« Last post by paramvir 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.

67

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

« Last post by omerix on March 17, 2025, 06:52:16 pm »

Yes, interestingly enough, sometimes the error does not appear in the console.

But if you try this, loadState doesn't seem to work when "colmodel" is used inside "colmodel".

- Drag and drop the "Order Date" column between the "Required Date" and "Shipped Date" columns.
- Then click the saveState button
- When you refresh the page and run the loadState function, you will see that the change has not been saved.

68

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

« Last post by RamC on March 17, 2025, 06:44:27 pm »

Hi
 
I had try this by removing "scrollModel.autoFit:  true", but then empty columns are showing on the right hand side of the grid, if columns has less in grid.
 
Also i have try with other jqueryUI version. but still not worked. Currently i am using jqueryUI version 1.14.1 which is latest version.
 
Thanks.

69

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

« Last post by RamC on March 17, 2025, 05:23:38 pm »

Thanks , Its working.

70

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

« Last post by paramvir 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/