Messages

1

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?

2

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.

3

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?

4

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.

5

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.

6

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?

7

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

8

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.

9

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?

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 / Re: Remote options

« on: January 25, 2023, 08:01:19 pm »

Great, thanks.

13

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.

14

Help for ParamQuery Pro / Re: Filter question

« on: January 19, 2023, 07:20:21 pm »

did like this:

Code: [Select]

if (rule.value != undefined || rule.value2 != undefined) {
  rule.value = undefined; //clear the values while keep the filter conditions.
  rule.value2 = undefined;
  grid.filter();//refresh filter.
  }

or is there a better way?

15

Help for ParamQuery Pro / Re: Filter question

« on: January 19, 2023, 07:04:47 pm »

By the way I would like to clear/refresh filter only if filter was set to avoid unnecessary call to db...what would be a good way to do this?