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

Pages: [1]
Help for ParamQuery Pro / Apply filter to Grid at Pivot mode (Pro 8.1.0)
« on: September 17, 2021, 11:41:00 am »

Before 8.0.1, I have a workaround for this.
1. turn off the pivot mode for the grid
2. apply the filter to the grid
Code: [Select]
            oper: 'replace',
            mode: 'AND',
            rules: [
                { dataIndx: 'FacilityName', condition: 'begin', value: filterFacilityName },
3. turn on the pivot mode for the grid
However, with 8.0.1 and 8.1.0, it seems the workaround is not working any more. At the 2 step, it complains an error of "Uncaught !primary.getDMData".

By the way, the loadState for Pivot mode with filter values is still not working.  The details are at

Hello there,

we want to sort the grp column by default.
Code: [Select]
groupModel: {
            checkbox: true,
            checkboxHead: true,
            on: true,
            pivot: false, //pivotMode
            summaryInTitleRow: 'all', //to display summary in the title row.
            header: false, //hide grouping toolbar.
            grandSummary: true,
            titleInFirstCol: true,
            titleIndx: 'grp',
            fixCols: false,
            dataIndx: ['Item'],
            groupCols: [], //grouping along column axis.
            collapsed: [true, true],
            agg: {
                Count: "sum"
            showSummary: [false], //to display summary at end of every group.
            title: [
                "{0} ({1})",
                "{0} - {1}"
            summaryTitle: {
                sum: ""
            }        },
sortModel: {

            sorter: [{ dataIndx: 'grp', dir: 'up' }],
            space: true,
            ignoreCase: true,
            multiKey: null,
            single: false

However it is not working. It shows the small triangle but actually it is not sorting.

we also want to keep the group sorted at the pivot mode. Still no luck.
If we choose another column other than the "grp" column - such as the Item column in the example, it works.

Any idea? thanks.

Bug Report / loadState failed when loading a grid (8.0.1)
« on: July 07, 2021, 03:25:03 pm »
I have a pqgrid with the pivot feature.
However it fails when loading the grid with the state maintenance (
It looks "this.panes" is not initialized when calling the method.
Any idea?
Code: [Select]
22794      setAttrPanes: function() {
22795        this.$ele.attr("panes", this.panes.filter(function($ele) {
22796                return $":visible")
22797            }).length)
22798        }

Uncaught TypeError: Cannot read property 'filter' of undefined
    at _pq.cToolPanel.setAttrPanes (
    at _pq.cToolPanel.showHideColPane (
    at _pq.cToolPanel.setHtml (
    at _pq.cToolPanel.refresh (
    at _pq.cToolPanel.onGroupOption (
    at handleListeners (
    at $.<computed>.<computed>._pq._trigger (
    at _pq.cGroup.option (
    at _pq.cGroup.option (
    at $.<computed>.<computed>.fn.loadState (

It should go to ParamQuery Pro 7.4 ~ 7.6.1 however my subscription is need of renew and I cannot post it there.
We have several web pages created using pqgrid and when jumping between them. It often complains this JavaScript error.

Uncaught TypeError: Cannot redefine property: nodeClose
    at Function.defineProperty (<anonymous>)
    at new e.cTree (eval at <anonymous> (jquery-1.10.2.min.js:21), <anonymous>:16:16031)
    at HTMLDocument.eval (eval at <anonymous> (jquery-1.10.2.min.js:21), <anonymous>:16:15883)
    at HTMLDocument.dispatch (jquery-1.10.2.min.js:22)
    at HTMLDocument.v.handle (jquery-1.10.2.min.js:22)
    at Object.trigger (jquery-1.10.2.min.js:22)
    at init.triggerHandler (jquery-1.10.2.min.js:22)
    at $.<computed>.<computed>.o._create (eval at <anonymous> (jquery-1.10.2.min.js:21), <anonymous>:10:1248)
    at $.<computed>.<computed>._create (jquery-ui.js:144)
    at $.<computed>.<computed>._super (jquery-ui.js:129)

Refreshing fixes it but it is too annoying.
ParamQuery Pro 7.1.0 is OK.

Any thoughts?

Help for ParamQuery Pro / How to auto adjust column width
« on: October 29, 2020, 01:25:24 pm »

I have a grid which allows user to select the columns to display. Two issues:

1. Is there a way to automatically adjust the grid's column width based on user's selection?

2. How to set the font size or the row height on the selection dialog?


we have a case that the database view has 5 million records. we want to avoid to retrieve all the records as it will get timeout and it also has impact on the server performance. with the remote type and the remote location, we can implement everything nice (of cause, local sort/filter/page has better performance than remote) except export as it inevitably retrieves all the records in one service call.

Any good solution for that?


I read the examples but found none to resolve this case:
when the page is loaded the first time, the grid just shows the empty table defined by the colModel.
When user clicks a search button on the toolbar, it starts to make the ajax call to load the dataModel and then fresh the grid.

Because we have millions of records in the DB (looks we have to apply remote filtering, paging and sorting rather than local) and it will be reasonable to show the grid after user fires the command.

Thanks in advance.

Help for ParamQuery Pro / How to add datepicker to the toolbar
« on: March 11, 2020, 10:53:38 pm »

Is there any way to add the date filters (fromDate and toDate) to the toolbar so I can use them for remote filtering?
JQuery-ui provides the Datepicker widget however I haven't figured out how to use it on the toolbar.

Thanks in advance.


I am applying the local filtering to my razor page by referring to

However it reports "Uncaught TypeError: this.toolbar is not a function".
I used a different jquery 1.10.2 than 1.9.1 because there is other javascript files depending on that version.
    <script src="~/Scripts/jquery-1.10.2.min.js"></script>

Any idea?
Thanks in advance.


Pages: [1]