Topics

1

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.

2

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?

3

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.

4

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.

5

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

6

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?

7

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

8

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.

9

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.

10

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

11

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?

12

Help for ParamQuery Pro / Datetime format

« on: October 05, 2022, 07:06:26 pm »

Hi

Having issue with datepicker.
Data is in format yy-mm-ddThh:mm:ss.
Column options:

Code: [Select]

dataType: 'date', format: 'yy-mm-dd hh:mm:ss', formatRaw: 'yy-mm-dd'
When selecting datepicker '2022-10-04' I get 2022-10-04 hh:10:ss...

I would like datepicker to only use date and ignore time...

13

Help for ParamQuery Pro / PHP select issue

« on: January 13, 2022, 01:28:01 am »

Hi

I display 20 rows per page. When going to next page and perform a search the SQL Query will be:

Code: [Select]

SELECT * FROM [table] where id like CONCAT('%', '123', '%') LIMIT 20, 20;
This will give 0 rows returned if there is less than 20 rows returned (1 for example)...how can I address this?

14

Help for ParamQuery Pro / Modify range values

« on: April 13, 2021, 12:35:57 pm »

Would it be possible to modify values used in range condition? Fetching values remotely from DB.

Have values like 'value a, value b' but would like them to be splitted by comma (,) in the filter menu for range condition, ex:

value a, value b becomes:

- value a
- value b

15

Help for ParamQuery Pro / Freeze columns with hidden columns

« on: March 25, 2021, 02:49:00 am »

It is possible to freeze columns based on visible columns instead of all?