Messages

271

Help for ParamQuery Pro / Refering to values

« on: May 23, 2017, 01:33:11 pm »

In render function I use "ui.rowData.[dataIndx]" which works fine.
But would it be possible to get the value without having a column defined for it?

Thanks.

272

Help for ParamQuery Pro / Re: Tooltipster in render function

« on: March 06, 2017, 08:24:59 pm »

Perfect! Thanks for quick help.

273

Help for ParamQuery Pro / Re: Tooltipster in render function

« on: March 06, 2017, 07:46:17 pm »

Great, thanks. Put a span outside grid to show effect when it works.

https://jsfiddle.net/tjgxwLda/

274

Help for ParamQuery Pro / Tooltipster in render function

« on: February 25, 2017, 06:37:29 pm »

Trying to use Tooltipster (http://iamceege.github.io/tooltipster/) in render function. The class is added to my img but it has no effect it seems.
Gives no error message and outside grid it works fine.

Any idea how to solve?

275

Bug Report / Re: saveState and columnSelector

« on: December 27, 2016, 05:33:45 pm »

Ok. Could you please provide an example how this could look like?
Thanks.

276

Help for ParamQuery Pro / Re: Performance

« on: December 23, 2016, 02:39:09 am »

No post needed, can be removed.

277

Bug Report / Re: saveState and columnSelector

« on: December 22, 2016, 06:02:14 pm »

It now seems to work (3.3.4) if a column has attribute hidden: false when loading the table.
However if a user hides the column with columnSelector and save it through saveState, after loadState the checkbox in columnSelector is still checked even though column is now hidden...

Also if a column has attribute hidden: true when loading the table, the saveState does NOT save the columnSelector changes (show column) to the column (checkbox will unchecked and column hidden) after loadState.

Is there a fix for this?

Thanks.

278

Help for ParamQuery Pro / Re: Performance

« on: December 17, 2016, 03:16:31 am »

Is that possible with dataModel local? Or do it need to be remote?
Also why doesn't virtualY: true have any effect on the current setup?

Thanks.

279

Help for ParamQuery Pro / Re: Performance

« on: December 15, 2016, 06:25:40 pm »

data.js is 170 MB, binding is around 150ms when using your timing example...

280

Help for ParamQuery Pro / Re: Performance

« on: December 15, 2016, 04:14:52 pm »

Code: [Select]

    <!-- jQuery dependencies -->
    <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
    <script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.11.4/jquery-ui.min.js"></script>

    <!-- ParamQuery Grid css files -->
    <link rel="stylesheet" href="paramquery-3.3.1/pqgrid.min.css" />
    <!-- Add pqgrid.ui.css for jQueryUI theme support -->
    <link rel="stylesheet" href="paramquery-3.3.1/pqgrid.ui.min.css" />

    <!-- ParamQuery Grid custom theme e.g., office, bootstrap, rosy, chocolate, etc (optional) -->
    <link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.11.4/themes/sunny/jquery-ui.css" />

    <!-- ParamQuery Grid js files -->
    <script src="paramquery-3.3.1/pqgrid.min.js"></script>
   
    <!-- DataSource -->
    <script src="data.js"></script>

    <script>

        $(function() {

            var colModel = [

                { title:"COLUMN_1", width:80, dataIndx: "COLUMN_1", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_2", width:80, dataIndx: "COLUMN_2", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_3", width:80, dataIndx: "COLUMN_3", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_4", width:80, dataIndx: "COLUMN_4", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_5", width:80, dataIndx: "COLUMN_5", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_6", width:80, dataIndx: "COLUMN_6", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_7", width:80, dataIndx: "COLUMN_7", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_8", width:80, dataIndx: "COLUMN_8", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_9", width:80, dataIndx: "COLUMN_9", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_10", width:80, dataIndx: "COLUMN_10", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_11", width:80, dataIndx: "COLUMN_11", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_12", width:80, dataIndx: "COLUMN_12", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_13", width:80, dataIndx: "COLUMN_13", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_14", width:80, dataIndx: "COLUMN_14", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_15", width:80, dataIndx: "COLUMN_15", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_16", width:80, dataIndx: "COLUMN_16", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_17", width:80, dataIndx: "COLUMN_17", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_18", width:80, dataIndx: "COLUMN_18", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_19", width:80, dataIndx: "COLUMN_19", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }},
                { title:"COLUMN_20", width:80, dataIndx: "COLUMN_20", filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }}
       
                ]
         
            var obj = {
           
                filterModel: { header: true }, 
                numberCell: { show: true },
                height: window.innerHeight,
                hoverMode: "row",
                title: "TEST",
                pageModel: { type: "local", rPP: 100 },
                editable: false,
                collapsible: { on: false,  toggle: false },
                virtualY: true,
                colModel: colModel,
                dataModel: { data: data }

            }

            var grid = pq.grid( "#grid_array", obj );

        });       
   
    </script>
         
    <body>
        <div id="grid_array"></div>
    </body>

data.js contains 200 000 rows like this:

Code: [Select]

var data = [

{ COLUMN_1: '1255295', COLUMN_2: '1091737', COLUMN_3: '1876437', COLUMN_4: '1811482', COLUMN_5: '1050546', COLUMN_6: '1735940', COLUMN_7: '1304513', COLUMN_8: '1244989', COLUMN_9: '1545409', COLUMN_10: '1464608', COLUMN_11: '1006538', COLUMN_12: '1693937', COLUMN_13: '1580089', COLUMN_14: '1846202', COLUMN_15: '1820061', COLUMN_16: '1561018', COLUMN_17: '1477287', COLUMN_18: '1669908', COLUMN_19: '1311600', COLUMN_20: '1476354' },
{ COLUMN_1: '1846202', COLUMN_2: '1050546', COLUMN_3: '1091737', COLUMN_4: '1811482', COLUMN_5: '1561018', COLUMN_6: '1820061', COLUMN_7: '1244989', COLUMN_8: '1477287', COLUMN_9: '1311600', COLUMN_10: '1464608', COLUMN_11: '1580089', COLUMN_12: '1669908', COLUMN_13: '1304513', COLUMN_14: '1255295', COLUMN_15: '1476354', COLUMN_16: '1735940', COLUMN_17: '1876437', COLUMN_18: '1693937', COLUMN_19: '1545409', COLUMN_20: '1006538' },
{ COLUMN_1: '1255295', COLUMN_2: '1561018', COLUMN_3: '1050546', COLUMN_4: '1811482', COLUMN_5: '1735940', COLUMN_6: '1476354', COLUMN_7: '1477287', COLUMN_8: '1876437', COLUMN_9: '1545409', COLUMN_10: '1464608', COLUMN_11: '1304513', COLUMN_12: '1693937', COLUMN_13: '1244989', COLUMN_14: '1846202', COLUMN_15: '1006538', COLUMN_16: '1820061', COLUMN_17: '1091737', COLUMN_18: '1669908', COLUMN_19: '1311600', COLUMN_20: '1580089' },
...
Thanks.

281

Help for ParamQuery Pro / Re: Performance

« on: December 15, 2016, 01:45:28 am »

I removed all render functions and the filling of the filter menus and now render 200 000 rows in like 5 seconds...I use:

Code: [Select]

        filterModel: { header: true }, 
        numberCell: { show: false },
        height: window.innerHeight,
        hoverMode: "row",
        scrollModel: {horizontal: true, vertical: true },
        title: "TEST",
        pageModel: { type: "local", rPP: 100 },
        editable: false,
        collapsible: { on: false,  toggle: false},
        virtualY: true,
        colModel: colModel,
        dataModel: {data: data},
still...virtualY:true doesn't seem to increase loading speed...it seems to be the same with or without?
What could cause it to not have any effect?

282

Help for ParamQuery Pro / Performance

« on: December 14, 2016, 06:53:35 pm »

Hi

I have a dataset with around 60 000 rows and 20 columns. The data is loaded through <script src="data.js"></script> where is its stored as JSON data (Array of row objects).
I use virtualY: true

It takes around 20 seconds to load the table in Chrome...What would be the easiest way to increase loading speed / filtering?

Thanks.

283

Help for ParamQuery Pro / Re: Custom HTML in toolbar

« on: December 08, 2016, 01:34:21 pm »

Thanks. However I tried that but in browser its rendered with a line break before and after. Rendered code (no line break):

Code: [Select]

...<button type="button" class="ui-button ui-widget ui-state-default ui-corner-all ui-button-text-icon-primary" role="button"><span class="ui-button-icon-primary ui-icon ui-icon-unlocked"></span><span class="ui-button-text">TEST BUTTON</span></button>

<div>This is my custom html</div>...
What I would like to have is the div positioned above the button (like a label) or the button written inside the div...is that possible?

Thanks.

284

Suggest new features / Re: Header filter

« on: December 08, 2016, 01:15:30 pm »

Yeah  , perhaps then a feature request for future releases (select all that matches search result)?

285

Help for ParamQuery Pro / Custom HTML in toolbar

« on: December 06, 2016, 08:47:27 pm »

I would like to add some labels (custom HTML) above some select boxes in the toolbar.
What is the best approch for this?

Thanks.