Recent Posts

Pages: [1] 2 3 ... 10
ParamQuery Pro Evaluation Support / Hide the column if the checkbox is checked
« Last post by Tejas on August 23, 2019, 01:08:24 pm »
Issue1. how can I hide the Unit Of measure column from the grid if the checkbox is checked.

Please refer the below link:

Show Unit Of measure:  <input type="checkbox" name="mycheckbox" id="mycheckbox" /> <br>
<div id="grid_editing" style="margin: auto;"></div>

    $(function () {

   var data = [
            { "id": "TH-P-P150-4", "UnitOfMeasure": "Kg", "Description": "HEX BOLT" },
            { "id": "TH-P-P150-5", "UnitOfMeasure": "PC", "Description": "PEN" },

        obj = {
            dragColumns: { enabled: false },
            hwrap: false,
            resizable: true,
            rowBorders: false,
            autoRow: false,
            rowHt: 50,
            trackModel: { on: true },
            scrollModel: { autoFit: true },
            editor: { select: true },
            colModel: [
                {title: "<span title = 'ITEM'>ITEM</span>", dataIndx: "id", width: 120, },
                { title: '<span title = "UNIT OF MEASURE">UNIT OF MEASURE</span>', width: 100, dataType: "string", dataIndx: "UnitOfMeasure" },
                { title: '<span title = "DESCRIPTION">DESCRIPTION</span>', width: 100, dataType: "string", align: "center", dataIndx: "Description", },

           dataModel: { data: data },

            postRenderInterval: -1, //synchronous post render.
            pageModel: { type: "local", rPP: 20 },

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


Issue2: Incase any of the column is hidden over here and I copy paste, then the data gets pasted also in hidden column how can I avoid it.

I kindly request you to reply as earliest as possible you can.

Thank you.

This workaround can be used

Add extra rows in dataReady event.

Code: [Select]
dataReady: function(evt, ui){
        //add any extra rows here by array manipulation of pageData.

Please note that being a workaround it may or may not work properly in upcoming versions.
Help for ParamQuery Pro / Re: fillhandle
« Last post by paramvir on August 22, 2019, 10:12:13 pm »
Please use beforeFillHandle event

Example: Following event handler can be used in this demo
to enable fillHandle only for 'OrderDate', 'ShipName', 'ShipRegion' columns.

Code: [Select]
beforeFillHandle: function(evt, ui){
if(['OrderDate', 'ShipName', 'ShipRegion'].indexOf(ui.dataIndx) == -1 ){
return false;
Help for ParamQuery Pro / fillhandle
« Last post by arbyter on August 22, 2019, 08:16:09 pm »
i would like enable fillhandle  just  on certain columns, not globally.
Can you give me an example?

Thank you
Help for ParamQuery Pro / Re: Performance Problem in Mozilla Firefox
« Last post by paramvir on August 22, 2019, 04:18:25 pm »
In firefox and Edge/IE, a short moment of blank space before rendering is normal as part of scrolling because rendering is slower in these browsers as compared to Chrome.

Is your implementation slower or has equal performance as ParamQuery demo:
Help for ParamQuery Pro / Performance Problem in Mozilla Firefox
« Last post by wrobel on August 21, 2019, 06:10:02 pm »
Hello ParamQuery Team,
i have some performance problems with ParamQuery in Mozilla Firefox and Mircrosoft Edge.
The tables are used without page numbers, i.e. infinite scrolling should be possible.
The browsers do not scroll up and down after displaying the data and need a certain time until they are displayed.
This results in a white area when scrolling until the data is displayed.
The problems only exist under Firefox and also in Edge. Google Chrome doesn't have these problems.
The data is loaded with PHP from a database and converted into a JSON format. The problem occurs even with smaller amounts of data.
As an example a table size of about 30x150 is generated.
Do you have an idea why this might be, or is it a general performance problem that it scrolls more smoothly in Google Chrome than in other browsers?
ParamQuery Pro Evaluation Support / Validation Issues
« Last post by virendraparade01 on August 21, 2019, 11:14:07 am »

Here in My project I have "ItemNo", "Qunatity", "TargetPrice", "Description", "PackingInstructions" defined by default. Now the new user is going to fill the required fields "ConfirmedQuantity", "ConfirmedPrice" and "LineTotal". But

1. when I try to Submit the Grid it directly throws an error, I don't know why even all the cells are field properly it throws an error.
2. No error or required symbol is displayed for the required cells even though I submit a empty grid.

can u plz let me know what's the issue here.

Issue Link:
Help for ParamQuery Pro / Re: Icons are very hard to see
« Last post by paramvir on August 21, 2019, 08:50:51 am »
Please check the topic on include files in tutorial section and ensure to use jQueryUI version >= 1.11.4

Look out for 404 errors in the browser console

It could also be due to conflict with some third party library ( in that case try to troubleshoot by removing the third party libraries one by one )

Kindly share a jsfiddle if you want me to check it for you.
Any rows in summaryData option are not counted in total rows in grid.

Example of usage of summaryData:
Help for ParamQuery Pro / Re: Icons are very hard to see
« Last post by akraines on August 20, 2019, 07:36:35 pm »
I dont think the missing buttons was a css issue. See my solution over there.

Either way here are all the css and js imports on the screen:
Code: [Select]
        <link href="/css/jquery-ui.min.css" rel="stylesheet" />
        <link href="" rel="stylesheet" />
        <link href="/css/Style.css" rel="stylesheet" />
        <link rel="stylesheet" href="" integrity="sha384-fnmOCqbTlWIlj8LyTjo7mOUStjsKC4pOpQbqyi7RrhN7udi9RwhKkMHpvLbHG9Sr" crossorigin="anonymous">
        <link href="//" rel="stylesheet">
        <script src="/js/jquery_2.2.4.min.js"></script>
        <script src="/js/jquery-ui.js"></script>
        <script src="/js/jquery.are-you-sure.js"></script>
        <script src="/js/jquery.validate.js"></script>
        <script src="/js/jquery.validate.unobtrusive.js"></script>
        <script src="/js/jquery.unobtrusive-ajax.js"></script>
        <script src="/js/chosen.jquery.js"></script>
        <script src="/js/moment.js"></script>
        <script src="/js/lodash.min.js"></script>
        <script src="/js/jquery.ui.autocomplete.html.js"></script>
        <script src="/js/chosen.order.jquery.js"></script>
        <script src="/js/shared.js"></script>
        <script src="/js/nav-controls.js"></script>
        <script src="/js/CustomValidators.js"></script>

<!--ParamQuery Grid css files-->
<link rel="stylesheet" href="/libraries/paramquery-6.1.0/pqgrid.min.css" />
<!--add pqgrid.ui.css for jQueryUI theme support-->
<link rel="stylesheet" href="/libraries/paramquery-6.1.0/pqgrid.ui.min.css" />
<!--ParamQuery Grid custom theme e.g., office, bootstrap, rosy, chocolate, etc (optional)-->
<link rel="stylesheet" href="/libraries/paramquery-6.1.0/themes/gray/pqgrid.css" />
<!--ParamQuery Grid js files-->
<script type="text/javascript" src="/libraries/paramquery-6.1.0/pqgrid.min.js"></script>
<!--ParamQuery Grid localization file (necessary since v5.2.0)-->
<script src="/libraries/paramquery-6.1.0/localize/pq-localize-en.js"></script>
<!--Include pqTouch file to provide support for touch devices (optional)-->
<script type="text/javascript" src="/libraries/paramquery-6.1.0/pqTouch/pqtouch.min.js"></script>
<!--Include jsZip file to support xlsx and zip export (optional)-->
<script type="text/javascript" src="/libraries/paramquery-6.1.0/jsZip-2.5.0/jszip.min.js"></script>
<!--Include jquery.resize to support auto height of detail views in hierarchy (optional)-->
<script type="text/javascript" src="/libraries/paramquery-6.1.0/javascript-detect-element-resize/jquery.resize.js"></script>
<script src="[email protected]/dist/FileSaver.min.js"></script>

Pages: [1] 2 3 ... 10