Messages

31

Help for ParamQuery Pro / Re: Tooltipster

« on: January 16, 2023, 11:22:26 pm »

Solved.

32

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

33

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?

34

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

35

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.

36

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?

37

Help for ParamQuery Pro / Re: Modify range values

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

Remote.

38

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.

39

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?

40

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

41

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?

 

42

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?

43

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

44

Help for ParamQuery Pro / Re: PHP session variables

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

Solved.

45

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 sessionsession_start();?>

Any idea what could be wrong?