1
Help for ParamQuery Pro / Re: BootStrap Dropdown not working
« Last post by pbassey on May 29, 2025, 07:55:12 pm »Perfect! Thank you...
ParamQuery Grid
Recent Posts
2
Help for ParamQuery Pro / Re: BootStrap Dropdown not working
« Last post by paramvir on May 29, 2025, 06:50:13 pm »grid cells have overflow: hidden; that's why the dropdown gets clipped.
It can be resolved by:
a) Either add style overflow: visible to the cells containing bootstrap dropdowns.
b) or add data-bs-popper-config='{"strategy":"fixed"}' to data-bs-toggle='dropdown' elements:
jsfiddle with 2nd solution:
https://jsfiddle.net/zyhcok5p/
More discussion about this issue:
https://stackoverflow.com/questions/31829312/bootstrap-dropdown-clipped-by-overflowhidden-container-how-to-change-the-conta
It can be resolved by:
a) Either add style overflow: visible to the cells containing bootstrap dropdowns.
b) or add data-bs-popper-config='{"strategy":"fixed"}' to data-bs-toggle='dropdown' elements:
jsfiddle with 2nd solution:
https://jsfiddle.net/zyhcok5p/
More discussion about this issue:
https://stackoverflow.com/questions/31829312/bootstrap-dropdown-clipped-by-overflowhidden-container-how-to-change-the-conta
3
Help for ParamQuery Pro / BootStrap Dropdown not working
« Last post by pbassey on May 29, 2025, 01:18:42 am »I am using a PG Grid that has an "Actions" column that has 3 buttons inside. The 3rd button is named "More" and is supposed to popup a bootstrap menu of 2 items (Export and Delete options), but is not working
Below is a link to jsfiddler that has the code I am using:
https://jsfiddle.net/7swe1L5d/
Notice that when you click on the "more" button inside the grid, nothing happens. However, when you click on the "more" button above/outside of the grid, it works fine. Because the menu works outside the grid, there must be an issue with the QueryParam options I am using.
Can you please tell me what I need to do to get this bootstrap popup working inside QueryParam?
Below is a link to jsfiddler that has the code I am using:
https://jsfiddle.net/7swe1L5d/
Notice that when you click on the "more" button inside the grid, nothing happens. However, when you click on the "more" button above/outside of the grid, it works fine. Because the menu works outside the grid, there must be an issue with the QueryParam options I am using.
Can you please tell me what I need to do to get this bootstrap popup working inside QueryParam?
4
Bug Report / Re: Safari 16 and below bug with suggested fix
« Last post by paramvir on May 28, 2025, 08:44:13 am »The original code uses a negative lookbehind
The following snippet can be used instead, as it avoids lookbehind by capturing the preceding character:
Code: [Select]
fmtPart = fmtPart.replace(/(?<![ap])m{1,5}/gi, replacer("M"));.
The following snippet can be used instead, as it avoids lookbehind by capturing the preceding character:
Code: [Select]
fmtPart = fmtPart.replace(/(^|[^ap])(m{1,5})/gi, (match, prefix, mSequence, offset) => {
return prefix + replacer('M')(mSequence, offset + prefix.length );
});
5
Help for ParamQuery Pro / Re: Why are cells marked as dirty with updateRow track: false?
« Last post by paramvir on May 25, 2025, 12:31:40 pm »Please pass the params correctly
Code: [Select]
grid.updateRow({
track: false,
history: false,
checkEditable: false,
refresh: true,
rowList: [{
rowIndx: ri,
newRow: res.data
}]
});
6
Help for ParamQuery Pro / Why are cells marked as dirty with updateRow track: false?
« Last post by omerix on May 24, 2025, 11:59:21 pm »Hello paramquery team,
Even though I set track: false, the updated cells are still marked as dirty (e.g., red triangle).
How can I prevent cells from being marked as dirty after updateRow?
res json
Thanks!
Even though I set track: false, the updated cells are still marked as dirty (e.g., red triangle).
How can I prevent cells from being marked as dirty after updateRow?
Code: [Select]
grid.updateRow({
rowList: [{
rowIndx: ri,
track: false,
history: false,
checkEditable: false,
refresh: true,
newRow: res.data
}]
});
res json
Code: [Select]
{
"pr": 0,
"data": {
"dr": 0,
"on": 1,
"kbl": 20,
"lock": false
}
}
Thanks!
7
Help for ParamQuery Pro / Re: PHP 7 -> PHP 8
« Last post by queensgambit9 on May 15, 2025, 07:30:08 pm »Solved, it's in the response from the db.
Seems as from PHP 8.1 PDO has been changed so that when MySQL returns an integer it will no longer be returned as a string.
Seems as from PHP 8.1 PDO has been changed so that when MySQL returns an integer it will no longer be returned as a string.
8
Help for ParamQuery Pro / Re: PHP 7 -> PHP 8
« Last post by paramvir on May 15, 2025, 05:27:41 pm »IS {"data":[{"c":1}} data of host grid or the remote filter options?
Could you share a jsfiddle.
Could you share a jsfiddle.
9
Help for ParamQuery Pro / PHP 7 -> PHP 8
« Last post by queensgambit9 on May 14, 2025, 05:37:32 pm »After upgrading from PHP 7 -> PHP 8 when loading a saved stated with columns that uses remoteOptions, The checkboxes are not populated correctly but the filter is applied correctly. Any idea what could be causing this?
Update:
Noticed that quotes are missing from numeric values in PHP 8 version.
Response PHP 7:
Response PHP 8:
State has "1" (with quotes).
Update:
Noticed that quotes are missing from numeric values in PHP 8 version.
Response PHP 7:
Code: [Select]
{"data":[{"c":"1"}}Response PHP 8:
Code: [Select]
{"data":[{"c":1}}State has "1" (with quotes).
10
Help for ParamQuery Pro / Re: Storing states in database
« Last post by paramvir on May 13, 2025, 08:05:26 pm »There is no demo for saving it in db as the process also involves user authentication to tie / associate the state with the user.
If you have user authentication already in place, then the process is quite simple:
first receive the state as string with saveState method and pass save: false to the method so as to avoid saving it to localStorage.
post the state string to remote url along with user token id and save it in a single field corresponding to the user in a table.
Get the state corresponding to the user whenever required and use loadState method to restore the state of the grid.
https://paramquery.com/pro/api#method-saveState
https://paramquery.com/pro/api#method-loadState
If you have user authentication already in place, then the process is quite simple:
first receive the state as string with saveState method and pass save: false to the method so as to avoid saving it to localStorage.
post the state string to remote url along with user token id and save it in a single field corresponding to the user in a table.
Get the state corresponding to the user whenever required and use loadState method to restore the state of the grid.
https://paramquery.com/pro/api#method-saveState
https://paramquery.com/pro/api#method-loadState