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

Pages: 1 ... 3 4 [5] 6 7 ... 9
61
Help for ParamQuery Pro / Re: loadState using State Parameter
« on: June 30, 2021, 01:41:43 am »
Works! Thanks. If I have a column filter applied to one viewstate and change to another viewstate (w/no filter), the filter remains. Any ideas on how to remove this for the viewstate which doesn't have a filter applied?

62
Help for ParamQuery Pro / Re: loadState using State Parameter
« on: June 29, 2021, 05:04:33 pm »
Thank you. That works. However, there's a scenario where I'm selecting a new grid state from a dropdown list without reloading the page and it's not working. Any ideas why?

                var obj = document.getElementById("selViews");
                var gState = obj.options[obj.selectedIndex].getAttribute('rpmGridState')
                const search = '\\"';
                const replaceWith = '"';
                const result = gState.split(search).join(replaceWith);
                success = $gridMain.pqGrid("loadState", { state: result });
                $gridMain.pqGrid('option', 'title', "Current View: " + obj.options[obj.selectedIndex].text);
                $gridMain.pqGrid("refreshView");

63
Help for ParamQuery Pro / Re: loadState using State Parameter
« on: June 28, 2021, 08:58:48 pm »
I'm using multiple grouping levels in my grid. Is there a way to save the expand/collapse state of a row in the savestate method? If not is there a strategy I could implement to achieve this?

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

65
Help for ParamQuery Pro / Re: Conditional Cell Formatting
« on: May 19, 2021, 07:45:32 pm »
Disregard my last request. At the moment I don't need to apply this grouping granularity. Thanks again.

66
Help for ParamQuery Pro / Re: Conditional Cell Formatting
« on: May 19, 2021, 04:57:25 pm »
Thank you. How can this be updated so that if grouped by 2 columns (company and rank) the sum is only displayed for 1 column (rank)

67
Help for ParamQuery Pro / Re: Conditional Cell Formatting
« on: May 11, 2021, 05:19:35 pm »
Hello, Can you please answer this? Thank you.

68
Help for ParamQuery Pro / Re: Conditional Cell Formatting
« on: May 04, 2021, 11:30:30 pm »
Is there a way to conditionally show a column's grouped sum only when grouped by a certain field?
For example, in this grid, for the month1 column, I want to show the sum when grouped by rank. If grouped by company, then don't show any value in the grouped header column. This would apply for 1 or many grouping levels.

https://jsfiddle.net/z3w2Lthc/

69
Help for ParamQuery Pro / Re: Conditional Cell Formatting
« on: April 06, 2021, 07:07:16 pm »
Thanks. "ParamQuery Pro Eval" is now removed. Also, I got the conditional format working after getting the latest grid version.

70
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 });

71
Help for ParamQuery Pro / Re: Conditional Cell Formatting
« on: March 31, 2021, 08:38:32 pm »
Thank you. I've downloaded v7.7.0 and updated the page's references to point to these. What's the next step remove "ParamQuery Pro Eval" from the page?

72
Help for ParamQuery Pro / Re: Conditional Cell Formatting
« on: March 16, 2021, 08:09:26 pm »
How do I determine the version? Also, my webpage displays "ParamQuaery Pro Eval" in bottom right, so I'm guessing I need to update my code?

73
Help for ParamQuery Pro / Re: Conditional Cell Formatting
« on: March 12, 2021, 07:14:44 pm »
Your example works, but when I transferred to my grid, it doesn't work.
I want to make a cell read only based on the value of another cell in the row. Can you correct/simplify below?
The breakpoint is getting hit at rd.CostCenter == "1296" but the cell remains editable.

                var colM = [
                    { title: "Reserve", width: 70, includeInSum: true, summary: { type: "sum" }, dataIndx: "STE_Hours_Reserved", datatype: "float", align: "right",
                        render: function (ui) {
                            var rd = ui.rowData;
                            var zz = rd.pq_cellprop = rd.pq_cellprop || {}
                            zz[ui.dataIndx] = {edit: true};

                            if (rd.CostCenter == "1296") {
                                zz[ui.dataIndx] = { edit: false };
                            }
                        }
                 ]
                    }
                ];

74
Help for ParamQuery Pro / Re: loadState using State Parameter
« on: February 24, 2021, 06:40:59 pm »
Yes, it actually does. Thank you!

75
Help for ParamQuery Pro / Re: Conditional Cell Formatting
« on: December 30, 2020, 09:24:15 pm »
Thank you. How could I also apply the logic make the cell read-only in addition to coloring it red?

Pages: 1 ... 3 4 [5] 6 7 ... 9