Topics

1

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

2

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.

3

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?

4

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?

5

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.

6

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?

7

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.

8

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.

9

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

10

Bug Report / Reorder columns

« on: February 14, 2023, 03:19:27 pm »

I can drag column but not possible to drop anywhere (red cross). Works fine in 8.2.0 but not in 8.7.0.
Did something change?

11

Help for ParamQuery Pro / Visual issues updating to 8.7.0

« on: February 06, 2023, 02:05:48 pm »

Hi, updated to 8.7.0 and I see some visual difference compared to earlier version 8.2.0.

The header background seems pushed down

Code: [Select]

.ui-widget-header {
    border: 1px solid #3f7506;
    background: #3a8104 url("images/ui-bg_highlight-soft_33_3a8104_1x100.png") 50% 50% repeat-x;
    color: #ffffff;
    font-weight: bold;
}
modifying background to:

Code: [Select]

background: #3a8104 url("images/ui-bg_highlight-soft_33_3a8104_1x100.png") 50% 0% repeat-x;
seems to fix the problem but the footer also seems wrong regarding the background...

Using:

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.3/jquery.min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.13.2/jquery-ui.min.js"></script>
<link rel="stylesheet" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.13.2/themes/le-frog/jquery-ui.css">

attached is screenshot

12

Help for ParamQuery Pro / Remote options

« on: January 23, 2023, 12:03:26 am »

Regarding https://paramquery.com/pro/demos/filter_remote_options.

I have multiple grids using jquery tabs and would like to have this function centralized to be used in all columns in all grids.

How could I implement this?

I send in table and column to PHP file which generates the sql to get distinct values which works fine,
but not sure how to centralize it so all tables and columns can use the same function.

13

Help for ParamQuery Pro / Hide current column from header context menu

« on: January 18, 2023, 02:16:31 pm »

Trying to hide current column from header context menu:

Code: [Select]

function headItems(evt, ui){
  return [
    {
          name: 'Hide column',
          action: function (evt, ui) {
     
            var grid = this,
            column = ui.column
           
            this.Columns().hide({ diHidden: [column.name] });
          }
    }
  ]
}
But can't get it to work properly.

14

Help for ParamQuery Pro / Tooltipster

« on: January 16, 2023, 07:43:28 pm »

Trying to set HTML content for tooltipster to button in toolbar in refresh event, but can't get it to work properly. Using title attribute on element works fine though...

toolbar with title attribute works:

Code: [Select]

type: 'button',
label: "toolbar_element",
attr: 'title="test"',
cls: 'tooltip'
toolbar with id and set content in refresh event (do not work):

Code: [Select]

type: 'button',
label: "toolbar_element",
attr: 'id="toolbar_element"',
cls: 'tooltip'
refresh event

Code: [Select]

$('.tooltip:not(".tooltipstered")#toolbar_element').tooltipster({
content: $('<span><strong>This text is in bold case !</strong></span>')
});

Old thread:
https://paramquery.com/forum/index.php?topic=1979

15

Help for ParamQuery Pro / Filter question

« on: January 16, 2023, 12:46:24 am »

Hi

I would like to clear filter (if exists) on a column when it changes from visible to hidden.
I used this before: https://paramquery.com/forum/index.php?topic=2355

Now using 8.7.0 with updated show / hide functionality how could it be implemented?