Messages

1

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

« 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 / PHP 7 -> PHP 8

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

3

Help for ParamQuery Pro / Storing states in database

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

4

Help for ParamQuery Pro / Re: Export in 10.1.0

« on: March 24, 2025, 02:52:59 pm »

Solved.

5

Help for ParamQuery Pro / Export in 10.1.0

« on: March 24, 2025, 01:33:57 pm »

Hi

After loading a state and doing an export hidden columns seems to be exported aswell. How can I prevent this from happening?

6

Help for ParamQuery Pro / Clear Text Icon in Header Filters

« 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?

7

Help for ParamQuery Pro / Re: Datetime format

« on: January 23, 2024, 12:35:42 am »

Follow up on this:

1. Does datepicker support "yy-mm-dd hh:mm", so user can select date and time?

2. Can you filter on only date and display full date and time in grid?. Example user selects 2024-01-22 and get all rows that match date regardless of time but still display it in grid?

8

Help for ParamQuery Pro / columnSelector 9.1.0

« on: December 01, 2023, 09:21:18 pm »

Hi

When using the column selector in 9.1.0 I get:

Code: [Select]

Uncaught TypeError: Cannot read properties of undefined (reading 'visible')
    at pqgrid.min.js:9:345466
Did something changed? Works fine with 8.7.0.

9

Help for ParamQuery Pro / Export value

« on: May 16, 2023, 12:47:31 pm »

Hi

Using 3 jquery tabs.
I use mumtiple toolbar definitions, One for tabs 1 and another for tab 2, 3. Having issue with export function where value from dropdown to select format is not picked from correct grid.
Example in tab 3 I choose csv but format is picked from grid in tab 2.

Do I need to have separate toolbar for each tab or can I reuse toolbar but handle logic to select drowdown from correct grid?

10

Suggest new features / Share saved state through url

« on: March 28, 2023, 01:09:42 am »

Possibility to generate url to share from current view / state which then can be loaded in browser.

11

Help for ParamQuery Pro / Paging toolbar

« on: March 21, 2023, 02:28:50 am »

Hi

Would it be possible to have a thousand separator in paging toolbar?

Ex:

Current:

Code: [Select]

Displaying 1 to 20 of 6235786 items.
Desired:

Code: [Select]

Displaying 1 to 20 of 6 235 786 items.

12

Help for ParamQuery Pro / Re: Remote filter

« on: February 19, 2023, 11:52:14 pm »

Solved. But how do I have separate (AND / OR) filtermodes for header filter and custom filter?

13

Help for ParamQuery Pro / Remote filter

« on: February 19, 2023, 11:01:11 pm »

Hi

Trying to implement the remote filter at https://paramquery.com/pro/demos/filter.
I also use header filter which has filtermode 'AND'. When above filter is used I want to use 'OR' instead. Tried:

Code: [Select]

this.option('filterModel', { mode : "OR" }in the filterhandler function but get error:

Code: [Select]

pqgrid.min.js:9 Uncaught TypeError: Cannot read properties of undefined (reading 'indexOf')

14

Help for ParamQuery Pro / Re: Visual issues updating to 8.7.0

« on: February 15, 2023, 12:11:16 pm »

There is a darker green area at the top starting to show. It will be greater as you add more object in toolbar that need more height.
I attached a screenshot.

15

Help for ParamQuery Pro / Re: Visual issues updating to 8.7.0

« on: February 15, 2023, 12:33:11 am »

Seems my toolbar (2 rows) push it down. I use

Code: [Select]

{type: '<br><br>'},
to get elements on second row and therefor I set height on toolbar.
What would be a better way to have 2 row toolbar?