Recent Posts

81

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

« Last post by paramvir 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();
}


82

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

« Last post by gopigupta on March 05, 2025, 08:03:51 am »

Hello,

I want to display tabular data as shown below on cell hover over. How can I achieve it?

Day	Date	Hours
Wed	05-Mar-2025	8.00
Fri	07-Mar-2025	8.00

Please let me know if you need more information
Thanks

83

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

« Last post by RamC on March 04, 2025, 05:40:29 pm »

Hello,

I have updated PQ Grid to Ver 9.1 from 3.3, and have some nested grids with "remote" Datamodel.
In newer version "Loading" box not displaying for nested grids , I also gone through https://paramquery.com/pro/demos91 and updated the code as well.

Please let me know if i missed any thing or have any other impacts.


Thanks.

84

Bug Report / New row comit and pq_detail column

« Last post by MichalV on March 03, 2025, 08:58:19 pm »

Hi Paramvir,

After the data saving the "add" commit fails if the grid includes pq_detail column (recIndx remains empty)
As a workaround I use the following code before the comit:

Code: [Select]

grid.Columns().find(function (column) {
    if (column.dataIndx == "pq_detail") {
        grid.Columns().hide({ diHide: ["pq_detail"] });
    }
});

And the following after the commit:

Code: [Select]

grid.Columns().find(function (column) {
    if (column.dataIndx == "pq_detail") {
       grid.Columns().hide({ diShow: ["pq_detail"] });
    }
});
Is it possible to fix it in the next release? E.g. skip the pq_detail column in the grid.commit function?
Thanks in advance for you help!

85

Suggest new features / An option to automatically set the cell title attribute

« Last post by jplevene on March 01, 2025, 12:13:19 am »

At the moment the only way to do it is in colModel.render:

Code: [Select]

render: function(ui){
return {
text: ui["cellData"], // This is not needed, included here for clarity
attr: 'title="'+ui["cellData"].replace('"',""")+'"'
}
}
When the column is narrow and the value is trimmed (if not multiline), the value is cut off, so hovering over to show the full value in the popup is nice for the user.

Also it would be nice to also be able to pass the attr as an object like:

attr: {
   "title": "Some message > this message & another bad char",
   "data-temp": "Some data variable"
}

EDIT: YOU CAN MAKE ATTR AN OBJECT.  I isn't mentioned in the API guide.

86

ParamQuery Pro Evaluation Support / Re: Preventing Row Height Transition When Applying CSS Styles to a Table

« Last post by cui on February 24, 2025, 07:39:46 am »

Row heights can be fixed by using rowHt option and set autoRow option to false.

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

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

I've encountered an issue: when I set autoRow: false, and then set wrap: true, the content does not display completely. I would like to ask how to solve this problem.

87

Suggest new features / Add a resized event

« Last post by jplevene on February 23, 2025, 04:18:31 am »

When the grid resizes, depending on your options like flex, etc, columns and rows get resized and or added to fit inside the grid.

It would be nice to have an event that is fired once all the resizing and render alterations have finished.

88

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

« Last post by jplevene on February 19, 2025, 08:22:37 pm »

I have added this with a resize observer, but it would be better to have this as a feature:

Code: [Select]

new ResizeObserver(function(){ setTimeout(function(){ grid_resize(); }, 100); }).observe( $("#grid")[0] );
...
function grid_resize()
{
if($("#grid").is(":visible"))
{
// Do we add horizontal scroll
var width = 0;
$("#grid").pqGrid("Columns").each(function(col){
if(!col.hidden)
width += intval(col["width"]);
});

// Do we hide or show the scroll bar
$("#grid").pqGrid("option", "scrollModel", {autoFit:width<$("#grid").width() ? true : false});
}
}

89

ParamQuery Pro Evaluation Support / Re: Preventing Row Height Transition When Applying CSS Styles to a Table

« Last post by cui on February 19, 2025, 01:52:31 pm »

Row heights can be fixed by using rowHt option and set autoRow option to false.

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

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

I adopted the solution you provided, and it solved my problem. Thank you very much for your help.

90

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

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