Messages

1

Help for ParamQuery Pro / Re: Can't expand a second tree branch when using remote data

« on: July 11, 2019, 12:29:26 am »

....Yep I see the issue.

Data is returning the same Id for the next results

we can close this.

2

Help for ParamQuery Pro / Re: Can't expand a second tree branch when using remote data

« on: July 10, 2019, 11:30:09 pm »

I have Id column and the values are unique. That's the value i'm passing on the sql query.

It's on the second request where things fail.

There is no check for duplicate ids in v4

3

Help for ParamQuery Pro / Re: Can't expand a second tree branch when using remote data

« on: July 09, 2019, 11:48:48 pm »

Same data and it works on PQGrid 4. Doesn't work on PQGrid 6

Treegrid is supposed to have one column with unique values.

Error is thrown when the values are not unique in that column.

Please see treeModel.id

https://paramquery.com/pro/api#option-treeModel

4

Help for ParamQuery Pro / Can't expand a second tree branch when using remote data

« on: July 09, 2019, 08:47:31 pm »

I can't expand a tree branch after expanding one already. Getting error "duplicate id".

The default data has 3 branches and the first query is the 4th and final branch. I can get the data on the first expansion of the 3rd branch, but if i try to expand another 3rd branch i get the error.

See attachments

5

Help for ParamQuery Pro / Re: PQGrid 4.0.1 - VScroll lock also locks row detail

« on: December 10, 2018, 11:14:48 pm »

Should also mention that even if I remove vscroll the row detail doesn't scroll

6

Help for ParamQuery Pro / PQGrid 4.0.1 - VScroll lock also locks row detail

« on: December 10, 2018, 11:04:13 pm »

I have a main grid that has row details. In the detail I load multiple tabs, each tab with a grid - all of the scroll, but for one tab I have plain html with css overflow. When the detail is expanded the main grid uses vscroll to lock its position to the top and only allow the detail to scroll. For the tab that uses only HTML the vscroll event fires immediately, which makes me think that the main grid thinks that it is its content. Any ideas on how this issue can be resolved?

7

Help for ParamQuery Pro / Re: ParamQuery Pro v3.3.2: Draggable

« on: October 16, 2018, 08:33:14 pm »

What did you end up doing for the drag and drop?

Hi,

Do you have a sample of the usage of the Draggable option?

What I'm trying to do is to enable dragging rows from one grid to another area, say a div, and perform some operations.

The user would select a few rows and start dragging them.

Right now the draggable option doesn't seem to do much.

If it's not supported, what can I do to enable this, thru custom code or prototype override?

Here is a sample of my grid initialization:

Code: [Select]

        var obj = {
            scrollModel: { autoFit: true },
            datatype: "json",
            showTop: false,
            numberCell: { show: false },
            selectionModel: { type: 'row', fireSelectChange: true },
            dataModel: {
                data: []
            },
            refresh: _refreshSearchGrid,
            colModel: cols,
            hoverMode: 'row',
            selectChange: _searchGridSelectionChange,
            draggable: true
        };

        _self.SearchGridSelector = "[id='" + context + "'] div[controlname='" + grid.GridName + "']"
        _self.SearchGrid = $(_self.SearchGridSelector).pqGrid(obj);



Thanks for your help.

8

Bug Report / Re: v5.0 shows issue with rowExpand

« on: May 03, 2018, 06:57:03 pm »

Thanks.

That worked.

9

Bug Report / v5.0 shows issue with rowExpand

« on: May 03, 2018, 01:30:21 am »

Background:
- Grid that was detail view
- If querystring is passed then a filter is applied
- In the Load event, the first row is then expanded by using rowExpand({rowIndx:0})

We are getting this error:

"0x800a138f - JavaScript runtime error: Unable to set property 'pq_ht' of undefined or null reference"

And this is what the debugger highlights:
"            initRowHtArrDetailSuper: function(t) {
                var e, n = this.rowhtArr,
                    r = this.data;
                t.forEach(function(t) {
                    e = t[0],n[e] = r[e].pq_ht = n[e] + t[1]
                }), this.setTopArr(), this.assignTblDims()
            },
"

I tried setting the rowData.pq_ht = 30 but that didn't do anything.

10

Help for ParamQuery Pro / Re: v5.0 number cell's selection doesn't select row

« on: May 02, 2018, 09:01:13 pm »

Yes, both options are being used and were not changed during the upgrade.

11

Help for ParamQuery Pro / v5.0 number cell's selection doesn't select row

« on: May 02, 2018, 12:40:13 am »

Selecting the Number cell doesn't select the row anymore. Any changes in documentation for this?

12

Help for ParamQuery Pro / pqGrid 5.0 lost ability to lock scrolling

« on: May 01, 2018, 10:03:16 pm »

What's the new method to lock scrolling? Now we have the events for scrolling, but even with a timeout of 1ms we see a jerking motion when resetting the scrolling to the current position.

13

Help for ParamQuery Pro / SelectionRow in Pro Version 4.0.1

« on: September 29, 2017, 09:53:11 pm »

Any reason why SelectionRow() is not found when I try to use it?

I am able to use rowSelect and I see other 4.0.1 changes (filtering) but not this method.

I have set the selectionModel to:

            selectionModel: {
                type: 'row',
                toggle: false,
                mode: 'block'
            },

and I to use the SelectionRow inside a toolbar button's listener for click events

14

Help for ParamQuery Grid (free version) / Re: examples for DB options for a select menu in the toolbar

« on: August 09, 2017, 02:19:50 am »

This can be closed. Just followed standard jquery:

 toolbar: {
      items[
                 {
                    type:'select',
                    options:
                                 $.getJSON("my/url", data, function(response){
                                                     $.each(response, function(index,item){
                                                              $('.selector').append($('<option>', {
                                                             value: item.Name,
                                                              text: item.Label
                                    }));
                                                                }
                                                }
                                   
              ]
}

15

Help for ParamQuery Grid (free version) / examples for DB options for a select menu in the toolbar

« on: August 08, 2017, 08:12:51 pm »

are there any examples for getting the values for a 'SELECT' item in the toolbar from the database?

currently have this

 toolbar: {
      items[
                 {
                    type:'select',
                    options:[ { "value1": "Description1" },
                                    { "value2": "Description2" }, 
                                ]
                 }
              ]
}

want something like this
 toolbar: {
      items[
                 {
                    type:'select',
                    options: function(){
                                var values = []
                                 $.getJSON("my/url", data, function(response){
                                                     $.each(response, function(index,item){
                                                               values.push(item)
                                                                }
                                                }
                                   }
              ]
}