Recent Posts

61

Help for ParamQuery Pro / Why are cells marked as dirty with updateRow track: false?

« Last post by omerix on May 24, 2025, 11:59:21 pm »

Hello paramquery team,

Even though I set track: false, the updated cells are still marked as dirty (e.g., red triangle).
How can I prevent cells from being marked as dirty after updateRow?

Code: [Select]

        grid.updateRow({
          rowList: [{
            rowIndx: ri,
            track: false,
            history: false,
            checkEditable: false,
            refresh: true,
            newRow: res.data
          }]
        });

res json

Code: [Select]

{
  "pr": 0,
  "data": {
    "dr": 0,
    "on": 1,
    "kbl": 20,
    "lock": false
  }
}

Thanks!

62

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.

63

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.

64

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).

65

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

66

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.

67

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"

68

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

69

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!

70

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"
},