Recent Posts

1

Help for ParamQuery Pro / Re: PHP 7 -> PHP 8

« Last post by queensgambit9 on May 15, 2025, 07:30:08 pm »

Solved, it's in the response from the db.
Seems as from PHP 8.1 PDO has been changed so that when MySQL returns an integer it will no longer be returned as a string.

2

Help for ParamQuery Pro / Re: PHP 7 -> PHP 8

« Last post by paramvir on May 15, 2025, 05:27:41 pm »

IS {"data":[{"c":1}} data of host grid or the remote filter options?

Could you share a jsfiddle.

3

Help for ParamQuery Pro / PHP 7 -> PHP 8

« Last post by queensgambit9 on May 14, 2025, 05:37:32 pm »

After upgrading from PHP 7 -> PHP 8 when loading a saved stated with columns that uses remoteOptions, The checkboxes are not populated correctly but the filter is applied correctly. Any idea what could be causing this?

Update:
Noticed that quotes are missing from numeric values in PHP 8 version.

Response PHP 7:

Code: [Select]

{"data":[{"c":"1"}}
Response PHP 8:

Code: [Select]

{"data":[{"c":1}}
State has "1" (with quotes).

4

Help for ParamQuery Pro / Re: Storing states in database

« Last post by paramvir on May 13, 2025, 08:05:26 pm »

There is no demo for saving it in db as the process also involves user authentication to tie / associate the state with the user.

If you have user authentication already in place, then the process is quite simple:

first receive the state as string with saveState method and pass save: false to the method so as to avoid saving it to localStorage.

post the state string to remote url along with user token id and save it in a single field corresponding to the user in a table.

Get the state corresponding to the user whenever required and use loadState method to restore the state of the grid.

https://paramquery.com/pro/api#method-saveState

https://paramquery.com/pro/api#method-loadState

5

Help for ParamQuery Pro / Storing states in database

« Last post by queensgambit9 on May 13, 2025, 01:16:55 pm »

Hi

I am currently using states (localstorage). Is there a tutorial or example on how to instead store in database along with user data. Using MySQL/PHP.

Thanks in advance.

6

Bug Report / Bugs in format for dates with times in a tree

« Last post by jplevene on May 03, 2025, 10:20:13 pm »

I spotted two bugs, but only if pqGrid is a treeModel

• "mm/dd/yyyy" does not work, I have to use "mm//dd/yyyy" (notice the double "//" to get a single one to show)
• "mm//dd/yyy hh:mm" does not work as documented, it shows the month instead of the minutes.

In one of the demos on the pqGrid v10 demo page I set "format" and/or "fmtDateFilter"

7

Help for ParamQuery Grid (free version) / Re: Prevent from adding new rows when pasting data.

« Last post by paramvir on April 29, 2025, 10:57:16 pm »

Sorry for late reply.

It can be done in beforeValidate, check if ui.source == 'paste' and there are objects of type: 'add' in ui.rowList, then remove them.

https://paramquery.com/api#event-beforeValidate

8

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

« Last post by mlipham on April 28, 2025, 09:34:59 pm »

Ah! Lovely - thank you sir!

9

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

« Last post by paramvir on April 28, 2025, 09:13:52 pm »

count can be added by updating summaryOptions for numbers.

Code: [Select]

summaryOptions: {
number: "avg,max,min,stdev,stdevp,sum,count"
},


10

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

« Last post by mlipham on April 28, 2025, 08:09:55 pm »

Yes - you are correct. After further analysis, I understand my ticket a little better - apologies.
And yes, the example behavior seems to match what I am seeing in our development.

Allow me to ask a follow-up.

The example https://paramquery.com/pro/demos/pivot has Gold in the aggregates box (lower right), along with Silver bronze and total.

After re-reading my (internal) request again, I think the question is - why is count not available for the number types?
Is that something I can code to add into the list of aggregate choices for numbers?

Many thanks as always!