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.

Topics - mikep

Pages: [1] 2
Help for ParamQuery Pro / Adding column with indicator icos
« on: July 29, 2021, 08:38:24 pm »
Do you have any example on how to create a column that can contain 0 to many indicator icons, based on the row's data?

Help for ParamQuery Pro / Filter: Set Default filter value
« on: July 27, 2021, 06:34:26 pm »
when clicking on a column filter, instead of [None] selected as default, can [Range] be selected as the default?

Help for ParamQuery Pro / Conditional Editable
« on: July 06, 2021, 11:51:18 pm »
I am able to make a column read only, based on its contents using the following:
                                colAP.render = function (ui) {
                                    var rd = ui.rowData; //.children[0];
                                    var zz = rd.pq_cellprop = rd.pq_cellprop || {};
                                    zz[ui.dataIndx] = { edit: false };
                                    if (rd["My Resource"].indexOf("Yes") > -1) {
                                            zz[ui.dataIndx] = { edit: true };

However, if user drags contents from another cell to this cell, its editable. How can I prevent a cell like above from not being editable on drag/fill?

Help for ParamQuery Pro / How to Remove Filter
« on: June 08, 2021, 04:51:05 pm »
I'm saving/loading grid settings in Database for users, which is working great. But when a filter is applied, the users are unable to remove the filter. Do you have any advice on how a user can remove a filter once applied? Changing the filter to "None" and clicking OK does not remove the filter or the filter icon from the colum.

I'm adding new rows to the grid, but need to make certain non-editable columns editable in order to populate w/data, then set these columns back to non-editable.
Here's my JS to add the data/rows. How can I make the columns editable, add the data, then make then non-editable again.

                        var newRowList = [];
                        for (i = 0; i < rpmData.length; i++) {
                            newRowList.push({ newRow: rpmData });
                        $gridMain.pqGrid("addRow", { rowList: newRowList });

Help for ParamQuery Pro / loadState using State Parameter
« on: September 15, 2020, 06:16:52 pm »
Saving/Loading from from browser storage works great, but when I send in the state using state parameter, it's ignoring this and just loading the browser stored state. Any suggestions?
var temp = "{'colModel':[{'dataIndx':'res','width':20}.......}";

Help for ParamQuery Pro / Row Totals for n-Columns
« on: August 29, 2020, 02:52:13 am »
Hi. I have a grid that displays a variable number of columns w/costs. What's the best way to have a column at the end of the grid that sums these columns?
In this example I have two columns that I need to sum, but it could be any number of columns

Help for ParamQuery Pro / Refresh Grid and Checkboxes disappearing
« on: May 18, 2020, 08:49:15 pm »
On the example above, if I click Refresh0 and then Refresh1, why do the checkboxes disappear?

Help for ParamQuery Pro / onchange event for cell
« on: May 14, 2020, 12:31:23 am »
How can I trigger an event when a user edits a cell value. For Example, when the user change the revenue cell, I want to set the profits column. I tried render, but that gets triggered too often.


Hi, when using freezeCols in the above example, If I make the columns wider and then scroll horizontally, is there a way to hide the cell text in the columns that are scrolling, when they move over the locked columns? It currently shows text from both columns when the columns are on top of each other.

Help for ParamQuery Pro / Conditional Cell Formatting
« on: April 10, 2020, 08:50:58 pm »
Hi, in the example below, I would like the cells to be formatted on initial load and when a profit or revenue value changes. I used your example from the website, but it's not working for me.

Help for ParamQuery Pro / Disable/Enable Grid
« on: April 03, 2020, 02:49:18 am »
Hi, How can I enable/disable the grid. I tried a method from the api documentation but not working.

I'm creating a new grid row in my dropModel:

dropModel: { drop: function (evt, uiDrop)
 $gridMain.pqGrid('addRow',  {newRow: {}}

1. The new row is added to the bottom of the grid. How can I add the row directly beneath the row where it was dropped?
2. How can I shade the BGColor of the new row?

Help for ParamQuery Pro / Detect changes
« on: March 05, 2020, 09:21:36 pm »
1. in my drop function, I'm setting a text value in the drop row's column, but when I call getChanges, the grid doesn't detect the change. If I manually change the text value, getChanges detects the change. How can I register the change in code? The below code doesn't detect the change.

drop: function (evt, uiDrop) { = "my new value that isnt detected"
   uiDrop.rowData.id1 = "mote new text"

var gridChanges = $gridMain.pqGrid("getChanges", { format: 'byVal' });

Help for ParamQuery Pro / Column Menu/Filter Icons missing
« on: March 02, 2020, 08:37:06 pm »
I am able to apply filtering to columns (menuIcon=true), but the icons are not visible. From the SDK, I added the images folder and have ensured the filter images are in the folder. Any ideas why images are not displaying for the column filter?

Pages: [1] 2