Messages

1

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

2

Help for ParamQuery Pro / Re: PHP select issue

« on: January 14, 2022, 01:50:51 am »

Thanks, had some error in my PHP for getting data.

3

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?

4

Help for ParamQuery Pro / Re: Modify range values

« on: April 14, 2021, 12:58:56 pm »

Remote.

5

Help for ParamQuery Pro / Re: Modify range values

« on: April 14, 2021, 12:24:44 pm »

I fetch filter values to populate range condition from DB (select distinct) to get all values and not only them available in grid. Tried using options but can't get it to work.
Seems to work when modifying the response from ajax call to get header options before assigning them.

Instead of equal condition in Range, I would like to use contain condition. Do I need custom override for this? Is there a sample available in that case?

Thanks.

6

Help for ParamQuery Pro / Re: Modify range values

« on: April 13, 2021, 05:41:09 pm »

Is there a way to do it in callback in the column definition or is the prefered way to do it in the response from ajax call before values are assigned as options?

7

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

8

Help for ParamQuery Pro / Re: Freeze columns with hidden columns

« on: March 28, 2021, 06:22:19 pm »

Thank you, seems to work but having issue with column headers overlapping when scrolling. Any idea what might be causing this?

 

9

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?

10

Help for ParamQuery Pro / Multiple search terms with condition

« on: March 17, 2021, 03:35:40 pm »

Hi

For contain condition would it be possible to use keywords to split string to multiple search terms?
Ex:

term1+term2+term3 generates (PHP) query to DB:

Code: [Select]

...WHERE a LIKE '%term1%' AND a LIKE '%term2%' AND a LIKE '%term3%'
instead of

Code: [Select]

...WHERE a LIKE '%term1+term2+term3%'

11

Help for ParamQuery Pro / Re: PHP session variables

« on: February 05, 2021, 06:21:47 pm »

Solved.

12

Help for ParamQuery Pro / PHP session variables

« on: February 02, 2021, 12:52:05 pm »

Having issue using session variables.
Variable is set on index page and works fine but when trying to access the variable on the php page which creates query to DB it seems to be undefined.

Using on both pages:

Code: [Select]

<?php
// Start the session
session_start();
?>
Any idea what could be wrong?

13

Help for ParamQuery Pro / Localstorage states

« on: December 14, 2020, 02:53:40 pm »

Hi

I would like domain A to have access to Localstorage states created on domain B.
Would that be possible with some redirect or similiar from B -> A?

14

Suggest new features / Hide column directly on column

« on: September 29, 2020, 01:47:58 pm »

Possibility to hide a column by clicking on a icon or similiar directly on column (not using the standard column selector).

15

Help for ParamQuery Pro / Customize loading icon

« on: September 22, 2020, 10:24:46 pm »

Can the appearance of the loading icon be customized?