Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - queensgambit9

Pages: 1 2 [3] 4 5 ... 23
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?


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?

Help for ParamQuery Pro / Multiple search terms with condition
« on: March 17, 2021, 03:35:40 pm »

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

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

Help for ParamQuery Pro / Re: PHP session variables
« on: February 05, 2021, 06:21:47 pm »

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]
// Start the session

Any idea what could be wrong?

Help for ParamQuery Pro / Localstorage states
« on: December 14, 2020, 02:53:40 pm »

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?

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

Help for ParamQuery Pro / Customize loading icon
« on: September 22, 2020, 10:24:46 pm »
Can the appearance of the loading icon be customized?

Help for ParamQuery Pro / Re: html tags in json.stringify
« on: June 09, 2020, 07:44:36 pm »

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

Help for ParamQuery Pro / Prism
« on: June 03, 2020, 05:59:59 pm »
Trying to implement prism ( 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 I need to modify it somehow to make it work with grid?

Help for ParamQuery Pro / Re: Custom filter
« on: May 29, 2020, 01:00:34 pm »
Hmm...not sure I understand what you mean. I'll try clarify a bit what I would like to have:

In addition to the standard filters, I would like to have a global filter possibility, ex:

User select some column filters and choose to apply global filter from custom dropdown value 'only team 1 in country b'. In PHP file I check this value and generate SQL for it (added to filterQuery).
That setting should be saved with the state so that the user do not have to select it manually again when loading their state and want to perform same search.

Does it make sense or is there a better way of this?

Help for ParamQuery Pro / Re: Custom filter
« on: May 28, 2020, 07:43:53 pm »
No, it is saved in localStorage. The state contain the custom data but it ain't sent to php on:

this.loadState({ state: state }) I need to modify postData somehow?
Other grid state info works fine.

Help for ParamQuery Pro / Re: Custom filter
« on: May 28, 2020, 05:50:17 pm »

Loading issue:
The custom values does not seem to be sent when state is loaded even though they are set in state...?
How do I send the custom values to php file?

Help for ParamQuery Pro / Re: Custom filter
« on: May 28, 2020, 03:05:08 pm »
Got it working by:

Code: [Select]
var state = this.saveState({ stringify: false });

var $toolbar = this.toolbar()
key = $toolbar.find(".filter100").attr('class')
value = $toolbar.find(".filter100").val()

state.key = value
state = JSON.stringify( state )


Pages: 1 2 [3] 4 5 ... 23