Topics

1

Help for ParamQuery Pro / Drag Drop column on ToolPanel sometimes not working in Chrome

« on: December 13, 2021, 04:10:30 pm »

Hello,

I has been confused for a while. Sometimes Chrome doesn't allow user to modify the columns in ToolPanel.

ParamQuery Pro v8.1.0
Google Chrome Version 95.0.4638.69 (Official Build) (64-bit)

I haven't experienced such problem with Firefox or Microsoft Edge yet.

Thanks,
Hua

2

Help for ParamQuery Pro / Apply filter to Grid at Pivot mode (Pro 8.1.0)

« on: September 17, 2021, 11:41:00 am »

Hello,

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]

grid.filter({
            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
https://paramquery.com/forum/index.php?topic=4087.0

3

Help for ParamQuery Pro / Sort by grp column with Group Model not working at normal mode and pivot mode

« on: September 01, 2021, 10:38:04 am »

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.

4

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 (https://paramquery.com/pro/demos/grid_state).
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 $ele.is(":visible")
22797            }).length)
22798        }

Uncaught TypeError: Cannot read property 'filter' of undefined
    at _pq.cToolPanel.setAttrPanes (pqgrid.dev.js:22795)
    at _pq.cToolPanel.showHideColPane (pqgrid.dev.js:22819)
    at _pq.cToolPanel.setHtml (pqgrid.dev.js:22773)
    at _pq.cToolPanel.refresh (pqgrid.dev.js:22717)
    at _pq.cToolPanel.onGroupOption (pqgrid.dev.js:22643)
    at handleListeners (pqgrid.dev.js:791)
    at $.<computed>.<computed>._pq._trigger (pqgrid.dev.js:836)
    at _pq.cGroup.option (pqgrid.dev.js:15838)
    at _pq.cGroup.option (pqgrid.dev.js:22358)
    at $.<computed>.<computed>.fn.loadState (pqgrid.dev.js:8784)

5

Help for ParamQuery Grid (free version) / Uncaught TypeError: Cannot redefine property: nodeClose

« on: June 08, 2021, 09:50:47 pm »

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?

6

Help for ParamQuery Pro / How to auto adjust column width

« on: October 29, 2020, 01:25:24 pm »

Hello,

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?

Thanks,
NZXGQ0

7

Help for ParamQuery Pro / remote or local retrieval/sort/filter/page/export for millions of records

« on: March 15, 2020, 04:11:10 pm »

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?

8

Help for ParamQuery Pro / Any way to load data after user clicks a search button on the tool bar

« on: March 11, 2020, 11:18:45 pm »

Hello,

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.

9

Help for ParamQuery Pro / How to add datepicker to the toolbar

« on: March 11, 2020, 10:53:38 pm »

Hello,

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.

10

Help for ParamQuery Pro / local filtering problem: Uncaught TypeError: this.toolbar is not a function

« on: March 11, 2020, 01:04:31 am »

Hello,

I am applying the local filtering to my asp.net razor page by referring to
https://paramquery.com/pro/demos/filter_local

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.

Hua