Topics

16

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?

17

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

18

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?

19

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

20

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?

21

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

22

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?




23

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?

24

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

25

Help for ParamQuery Pro / Customize loading icon

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

Can the appearance of the loading icon be customized?

26

Help for ParamQuery Pro / html tags in json.stringify

« on: June 09, 2020, 05:36:32 pm »

Trying to create clickable link inside json string... in column.render:

render: function (ui) {
        data = JSON.parse(ui.cellData)
        a = data.test
        a.forEach(function(i, j){
        data.test[j].attr ="<a href='http://www....' target='_blank'>test</a>"
            })
        }
        return JSON.stringify(data)

but it won't render correctly in browser...

27

Help for ParamQuery Pro / Prism

« on: June 03, 2020, 05:59:59 pm »

Trying to implement prism (prismjs.com) to highligt json data.

Using in render callback:

Code: [Select]

return '<pre class="language-json"><code class="language-json">' + (JSON.stringify(JSON.parse(ui.cellData), null, 2)) + '</code></pre>' } },
But can't get it work...code is displayed but prism class doesn't seem to be applied...do I need to modify it somehow to make it work with grid?

28

Help for ParamQuery Pro / Custom filter

« on: May 25, 2020, 07:37:43 pm »

I would like to apply a global filter and have that setting saved along with state data.
Would that be possible?

Ex. User selects 'a' from dropdown which applies

Code: [Select]

WHERE b = 1 to the select from DB.

Using PHP.

29

Help for ParamQuery Pro / Reload tab

« on: February 14, 2020, 03:47:13 pm »

Trying to reload active tab when clicking on title in grid...use onclick in title definition or is there a better way?

30

Help for ParamQuery Pro / Custom column data

« on: February 13, 2020, 01:39:58 am »

I would like to get an external source (html page, with using value from other column as qs) and display it in a column, something like:

Code: [Select]

$(document).ready(function(){
            $("#mydiv").load("http://xxx.yyy?a=[ui.rowData.column]);
       });

       <div id="mydiv"></div>
How can I do this?