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.


Messages - nklapper

Pages: [1] 2
1
Help for ParamQuery Pro / PDF output or best workaround
« on: August 17, 2017, 01:11:18 am »
I believe that output to PDF support has not yet been completed.

Could you please suggest a practical workaround?  Perhaps export to CSV or XLS and then use some other server-side tool to produce the PDF?

Thanks.

2
Hello,

I have a grid with a filter row for all columns, and it works fine. 

Now I need to hardcode a filter value for one particular column, e.g. WHERE `columndate` >= someTimeStamp, while still allowing user controlled filtering for all the other columns.

What is the best way to accomplish this?  Can you provide an example?

Thanks.

3
Help for ParamQuery Pro / Re: proper use of Flex
« on: June 28, 2016, 12:16:26 am »
Perfect.

That did the trick.

Thanks!

4
Help for ParamQuery Pro / Re: proper use of Flex
« on: June 27, 2016, 07:22:35 pm »
So sorry for the obvious error, I should have spotted that.

Grid now displays and columns are resizable, but the columns are no longer "flexed" as they were before to effectively no-wrap.

Please see attached screen capture.

Thanks!

5
Help for ParamQuery Pro / Re: proper use of Flex
« on: June 27, 2016, 07:04:23 pm »
I made your suggested changes as follows:

/*
         pq.grid("#grid_php", obj)
            .on("refresh refreshCell", function (evt, ui) {
            if (ui.source != 'flex') {
                    this.flex();
                }
            });
*/
         
         pq.grid("#grid_json", obj)
            .on("refreshCell", function (evt, ui) {
                if (ui.source != 'flex') {
                    this.flex();
                }
            });


______________________________________________________________

It produces this error: "Uncaught TypeError: Cannot read property 'on' of null"

6
Help for ParamQuery Pro / proper use of Flex
« on: June 24, 2016, 09:53:55 pm »
I would like my grid to use Flex and still allow resize of columns.  Is this possible?  I have tried several API methods, and Flex works, but cannot make the columns resizable.

Here is the relevant code:

      var obj = {
      //width: "flex",
      flexWidth: true,
      height: "flex",
      maxWidth: '98%',
        dataModel: dataModel,
        colModel: colM,
        //scrollModel:{pace: 'fast', autofit:true, theme: true },
        showTop : false,
        editable: true,
        sortModel: {
         on: true,
         sorter:[ { dataIndx: "deviceID", dir: "up" } ],
         multiKey: 'shiftKey',
         type: 'remote'
         },
      //stripeRows: true,
        resizable: true,
        columnBorders: true,
        freezeCols: 1,
      filterModel: { on: true, mode: "AND", header: true, type: "remote"},
        selectionModel: { type: 'cell' },
        pageModel: { type: 'remote', rPP: 15, rPPOptions:[10, 15, 25, 50, 100, 250, 500]},
        numberCell: {show: false},
      //flex: { one: true }
      };

7
I might be.  Would this apply to ALL columns, or just ONE specific column?

8
When using the Flex layout on a grid with a Filter row, the columns render much wider than necessary.

(see attached screep cap)

Is there an easy way to control this?  If not, please consider this a feature request to improve this behavior in a future release.

Thanks!

9
cls: Class to be assigned to whole column including header.

Is there a way to apply a Class to whole column except for the header?

10
ParamQuery Pro Evaluation Support / Problem using flex
« on: May 28, 2016, 01:25:27 am »
I tried to use exactly the code in http://paramquery.com/pro/demos/flex

but it does not work.

Here is the code:

  $(function () {

      //define colModel
        var colM = [
            { title: "Device ID", dataIndx: "deviceID", filter: { type: 'textbox', condition: 'contain', listeners: ['change']} },           
            { title: "Customer Name",  dataIndx: "dataONE", filter: { type: 'textbox', condition: 'contain', listeners: ['change']} },
            { title: "App Name",  dataIndx: "appNAMEold", filter: { type: 'textbox', condition: 'contain', listeners: ['change'] } },
            { title: "Customer Name",  dataIndx: "dataONE", filter: { type: 'textbox', condition: 'contain', listeners: ['change']} },
            { title: "App Name",  dataIndx: "appNAMEold", filter: { type: 'textbox', condition: 'contain', listeners: ['change'] } },
            { title: "Customer Name",  dataIndx: "dataONE", filter: { type: 'textbox', condition: 'contain', listeners: ['change']} },
            { title: "App Name",  dataIndx: "appNAMEold", filter: { type: 'textbox', condition: 'contain', listeners: ['change'] } },
            { title: "Last Launched",  dataIndx: "lastLAUNCH", dataType: "date", filter: { type: 'textbox', condition: "between", init: pqDatePicker, listeners: ['change'] } }
        ];
      //define dataModel
      var dataModel = {
          location: "remote",
          paging: "remote",
          dataType: "JSON",
          method: "POST",
          curPage: 1,
          filterIndx: "",
          filterValue: "",
/*---->*/ url: "test10tdata.php", //************************************************************************************
        postData: function(){ var obj = {pq_curpage: this.curPage, pg_rpp: this.rPP}; return obj;},
        getData: function ( dataJSON ) {               
            return { curPage: dataJSON.curPage, totalRecords: dataJSON.totalRecords, data: dataJSON.data };
        }
      }
 
      var obj = {
      width: 'flex',
      flex: { one: true },
      maxWidth: '100%',
      height: 430,
        dataModel: dataModel,
        colModel: colM,
        scrollModel:{pace: 'fast', autoFit: true, theme: true },
        showTop : false,
        editable: true,
        sortable: false,
        resizable: true,
        columnBorders: true,
        freezeCols: 1,
        filterModel: { on: true, mode: "AND", header: true },
        selectionModel: { type: 'cell' },
        pageModel: { type: 'remote', rPP: 15, rPPOptions:[10, 15, 25, 50, 100]},
        numberCell: {show: false}
      };

     // var $grid = $("#grid_php").pqGrid(obj); // if this is replaced with the code below, it does not work

   //////////////////////////////////////////////////////////////////
     pq.grid("#grid_php", obj)
      .on("refresh refreshCell", function (evt, ui) {
         if (ui.source != 'flex') {
            this.flex();
         }
      });
   //////////////////////////////////////////////////////////////////
   
    $grid.one("pqgridload", function (evt, ui) {
        $grid.pqGrid("refreshHeader");
      });
      
  });

11
ParamQuery Pro Evaluation Support / column > dataType
« on: May 24, 2016, 10:37:57 pm »
What are all the options for column > dataType  ?

I could not find a list in the API documentation.

Is datetime supported?  If not, what is the best workaround?

12
Is it possible to format the numbers rendered in grid cells, pager control and row number column?

With large datasets, it improves readability to include commas.

1,000,000 is easier to read than 1000000.

13
I have looked through the documentation, but I can find nothing that explains any relationship between:

 <link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.9.2/themes/base/jquery-ui.css" />

and your

pqgrid.ui.min.css and pqgrid.min.css

I would like to render a grid that looks like the 12.05.jpg screen capture (attached), which is from one of your demos.

The 12.07.jpg screen capture is my code, with the jqueryui theme set to "base".

If I change the theme to "dark-hive", it somewhat resembles your demo, but as you can see in the 12.10.jpg screen capture, it is not quite right.

Could you please explain, or point me to the relevant documentation?

Many thanks.

14
I received no response, so...

Should I assume that Server-side Filtering and Servier-side Paging on the same grid is NOT supported?

Please let me know.

15
Thank you for the quick reply.

I found a syntax error on one of my CSS includes.

It works now.

Pages: [1] 2