Topics

1

Suggest new features / TypeScript Support

« on: November 23, 2016, 01:05:41 am »

Hello,

Do you or will you be providing type definitions for TypeScript similar to those provided by http://definitelytyped.org/

Thanks

Paul

2

Help for ParamQuery Pro / jQuery 1.12 support

« on: August 08, 2016, 08:13:08 pm »

Hello

Paramgrid uses the jQuery UI zIndex function:
https://api.jqueryui.com/zIndex/

However, this function has been removed from version 1.12 of jQuery and so the grid no longer works with this version.
https://jqueryui.com/upgrade-guide/1.12/#removed-zindex

(I am using v3.2.0 of the grid).

Please can you advise if later versions of the grid will support later versions of jQuery.

3

Help for ParamQuery Pro / Remote Data

« on: July 17, 2015, 04:35:35 pm »

Hello,

I am currently using local data, local header filtering and local sorting in my grid.
I want to start using remote data, remote header filtering and remote sorting and your demos show me how I can do this.

However, in addition to the ObjectModel, ColumnModel and DataModel required by pqgrid, I also use additional meta data about the rows, columns and cells that I store in JSON objects outside of the grid.  This meta data is used to help render the grid (through colModel.render) and for other functionality used outside of the grid.

Question 1: If I implement a URL for handling pqGrid requests for data and filterered data, Should I use dataModel.getData and dataModel.postData so that I can include my own meta data in the request and response sent to the server?

Question 2: Other than some snippets in your demos, do you have documentation on the structure of the JSON objects sent to the server in the case of fetching paged/filtered/sorted data?

In order to use 'remote' data, I will need to create server side classes that I can deserialise the JSON from pqGrid into.  This essentially couples my pqgrid code on the client to server side code in a way that is not currently done and will mean that I have to ensure that my server side code is kept up to date with future releases of pqgrid.

Question 3: I think I would prefer to be able to use a callback method to fetch data instead of having to specify dataModel.Url or dataModel.getUrl.  In this way I can use my own AJAX framework to send and receive both pqgrid data as well as my own meta data and keep the pqgrid code decoupled from the server side code.  Is this currently possible or will you be able to implement this in a future version of pqGrid?

Question 4:  Could I use dataModel.beforeSend to intercept requests and return false.  I can then get beforeSend to carry out my own call to the server and then call 'refreshView' on return.  Does beforeSend have access to the JSON specifying filter and sort information?

Thanks very much

4

Help for ParamQuery Pro / Column Events

« on: May 26, 2015, 08:44:40 pm »

Please could you add events to the API so that I can create custom code to handle changes to column order, sort direction, sort index etc  in the same way that you have the columnResize event.

5

Help for ParamQuery Pro / Setting Height after initialisation

« on: May 06, 2015, 03:10:11 pm »

Please can you confirm how to change the height of the grid after initialisation.

I have tried using

Code: [Select]

$("#grid_filter").pqGrid("option", "height", 300);
as suggested by the help:
http://paramquery.com/pro/api#option-height

but it is not working.  Please see jsfiddle here for example:
http://jsfiddle.net/RedBully/b6b710mz/101/

I plan to have a height of flex but to change the height to 500px if the flex height exceeds 500px.  Alternatively, do you plan to implement a maxHeight option for the grid?

Thanks in advance

6

Help for ParamQuery Pro / Documentation

« on: May 05, 2015, 07:18:56 pm »

I'm currently going through a very painful process of upgrading from v2.1.0 to 2.4.1 and better documentation would make my work easier and reduce the amount of support requests I (or others) need to make.

For example, it appears that there is a subtle change to the use of EditModel within the ColumnModel.  My code currently sets the clicksToEdit property on a column by column basis but I don't believe this functionality is supported any longer in v.2.4.1.  It seems that clickToEdit is now only supported in the global editModel.

I checked the forum to see if I could find a note on this change in functionality but could not.  At first, I thought it might be a bug in the paramgrid code so I'd thought I'd check the documentation before posting to the forum.

The documentation for the column model editModel (
http://paramquery.com/pro/api#option-column-editModel)

says:
"it overrides the global editModel properties"

leading one to think that any of the editModel properties can be modified.

However, on inspection of the main editModel help
http://paramquery.com/pro/api#option-editModel

There is a small paragraph near the end of the main block under the invalidClass section that says
"Note that editModel options filterKeys, keyUpDown & saveKey can be overridden in the individual columns (column.editModel)"

This badly placed paragraph is not clear enough.  I spent a lot of time trying to work out why my code had just stopped working correctly when I did my upgrade.

Would you consider changing the documentation to a wiki so that members of the forum can edit and update the documentation to make it better for all.  Naturally, changes would have to be moderated but I think this could really help.

Thanks in advance

7

Help for ParamQuery Pro / Column Filter Callback

« on: May 05, 2015, 05:51:47 pm »

Dear Sirs,

I have just upgraded from Pro 2.1.0 to 2.4.1
I have a callback on a header filter in my grid that has stopped working since the upgrade.

Please can you confirm the correct use of type and init callback functions because it is not clear in the documentation or examples that I have checked
http://paramquery.com/pro/api#option-column-filter
http://paramquery.com/pro/demos/filter_header_local

I am using the callback so that I can render a select dropdown using the Select2 jquery plugin
https://select2.github.io/

Here is part of my column model:

Code: [Select]

filter:
{
type: function (ui) { return oa.renderMultipleChoiceFilter(this, ui); },
init: function (ui) { oa.initMultipleChoiceFilter(this, ui); },
condition: 'range',
listeners: ['change']
}

where

Code: [Select]

oa.renderMultipleChoiceFilter(this, ui)
returns a string containing a '<select>.....</select>' element
and

Code: [Select]

oa.initMultipleChoiceFilter(this, ui);initialises the select2 functionality.

I have tried removing the init function and hardcoded a select statement in the type call back but it still does not work:

Code: [Select]

filter:
{
     type: function (ui) { return '<select><option value=1>Test</option></select>'; },
     condition: 'range',
     listeners: ['change']
}

Thanks for your help

8

Help for ParamQuery Pro / Glyphicon not rendering

« on: January 08, 2015, 03:00:53 pm »

Hello,

I'm trying to render a glyphicon in a table cell by using the render function to set the cell content to
 

Code: [Select]

<span class='glyhicon glyphicon-search'></span>
On loading the page and inspecting the code, the grid cell looks ok:

Code: [Select]

<td class="pq-grid-cell " pq-col-indx="0">

    <span class="glyphicon glyphicon-search">
    </span>

</td>

But the icon is not rendering correctly.  I get a square block with E00E in it which is the type of icon I would get if the glyphicon library was not being referenced correctly.  The icons display correctly in the rest of the web page so I was wondering why they are not showing correctly here.

(I'm using both font-awesome and glyphicons in my webiste and have the same problem with both)

Any ideas?

9

Help for ParamQuery Pro / rowDblClick on filtered rows

« on: November 03, 2014, 11:08:47 pm »

Hello,

I'm using paramgrid with header filtering.  I'm using rowDblClick and I need to identify the row that has been double clicked.

I initialise my grid with:

Code: [Select]

rowDblClick: function (event, ui) { handleDoubleClick(event, this, ui); },

and I have

Code: [Select]

handleDoubleClick = function(event, grid, ui) {
  var rowIndx = ui.rowIndx;

  //Do something with this row Index
}

This works fine until I filter the list using header filtering.
If the list is filtered, then the rowIndx is the index of the row with respect to the filtered data

e.g. If I have data with 10 rows and then filter so that only rows 7 and 8 are shown, rowIndx for the first row is 0 instead of 7 as expected

I need the index of the row with respect to the data, not with respect to the filtered data set.
I can get ui.rowData but this just gives me the data from the row and not the index of the row.

Is it possible to get the index of the row with respect to the data?

Thanks in advance
 

10

Help for ParamQuery Pro / Using callback for column filter

« on: November 03, 2014, 05:58:07 pm »

I'm trying to use the callback for filter type as per
http://paramquery.com/pro/api#option-column-filter

type can be textbox, textarea, select, checkbox, callback function, html string or null. subtype can be triple for tri - state checkbox.

In my column model, I use

Code: [Select]

filter:
{
type: function (ui) { oa.renderFilter(this, ui); }
},

where my called method is

Code: [Select]

oa.renderFilter = function (grid, ui) {
        return "<div>Test</div>";
}

The table cell where the filter should be rendered is empty:

Code: [Select]

<td class="pq-grid-col"><div class="pq-grid-header-table-div" style="padding:0px 2px;"></div></td>

Am I correct to be returning html which should then be rendered or am I using the callback incorrectly?

I couldn't find a suitable example to copy in
http://paramquery.com/pro/demos/filter_header_local

11

Help for ParamQuery Pro / saveEditCell error

« on: April 15, 2014, 01:12:37 pm »

Trying to call saveEditCell on change event of a ddl/ select but getting:

Unhandled exception at line 248, column 3 in http://oang.localhost/Scripts/jquery-2.1.0.js
0x800a139e - JavaScript runtime error: cannot call methods on pqGrid prior to initialization; attempted to call method 'saveEditCell'

Though clearly the Grid has been initialised so is this error misleading and hiding the actual issue?

Column definition:

Code: [Select]

{ title: 'FormType', editable: function (ui) { return oa.IsCellEditable(this, ui); },
render: function (ui) { return oa.RenderCell(ui, XPPPPf_PageoptionsFormType); },
width: 200,
dataType: 'multiplechoice',
 editor: { type: function (ui) { return oa.editCell(this, ui, XPPPPf_PageoptionsFormType); }, getData: 'oa.getCellDataForSaving' }
},
oa.editCell is a generic function for handling all cell edit UI:

Code: [Select]

oa.editCell = function (context, ui, arr) {
.
[determine datatype from JSON based on cell cords]
.
if (datatype == constants.PropertyDataType.MultipleChoice) {
 
                       return oa.editMultipleChoiceCell(context, ui, arr);
                   }

oa.editMultipleChoiceCell = function (context, ui, arr) {
 
    oa.log('ParamGrid: Editing MultipleChoice Cell');
 
    var $cell = ui.$cell;
    var data = ui.data;
 
    //this won't work with Pro API
    //var cellData = $.trim(data[ui.rowIndx][ui.colIndx]);
    var cellData = $.trim(ui.rowData[ui.column.dataIndx]);
 
    var str = "";
    for (var i = 0; i < arr.length; i++) {
 
        var label = arr[i].label;
        var value = arr[i].value;
 
        if (cellData == value)
            str += "<option value='" + value + "' selected='selected'>" + label + "</option>";
        else
            str += "<option value='" + value + "'>" + label + "</option>";
    }
    var sel = $("<select style='width: 100%; height: 100%'>" + str + "</select>")
    .appendTo($cell);
    //not working - syntax wrong?
    $(sel).change(function() {
        oa.log('********** selection made');
        //one of these are failing
        $(context).pqGrid("saveEditCell");
        //$(context).pqGrid("quitEditMode");
        executeParaGridSaveCommandSet(null, ui, context);
    });
    }

?

Ta.

12

Help for ParamQuery Pro / different editors in same column

« on: April 11, 2014, 01:46:43 pm »

Hopefully this one will post successfully. I'll add as an attachment as well in case not.

I am aware the param query grid is quite column centric in its design and implementation. We are trying to step out of this a little and are passing down grid metadata in JSON which we then want to consume in callback functions. This worked OK for editable and render but we

13

Help for ParamQuery Pro / jQuery selector to grid enclosing div

« on: April 07, 2014, 03:09:23 pm »

I have a grid object defined in a .js:

oa.pqGridDefaultObject =
    {
        flexWidth: true,
        flexHeight: true,       
        //numberCell: { resizable: true, title: "#", width: 30, minWidth: 30 },
        collapsible: false,
        scrollModel: { horizontal: false },
        showHeader: true,
        showTitle: false,
        //topVisible: false,
        //bottomVisible: false,
        showBottom: false,
        selectionModel: { type: 'none', subtype: 'incr', cbHeader: true, cbAll: false },
        //numberCell: true,
        editable: true,
        //editor: { type: 'textbox' },
        rowDblClick: executeParamGridCommandSet,
        cellSave: executeParaGridSaveCommandSet,       

etc.

This is attached to a div as follows:

var VRfGPf_Pageobj = oa.pqGridDefaultObject;

14

Help for ParamQuery Pro / boolean column rendering

« on: April 04, 2014, 07:13:28 pm »

I've a customer requirement for a Boolean column in a grid where a checkbox is immediately exposed to allow editing of the value without the 'click to edit' model which seems prevalent in the paramgrid out of the box. Couldn't see a similar demo at quick review. Easy to do?

Cheers.

15

Help for ParamQuery Pro / datepicker UX

« on: April 04, 2014, 07:10:19 pm »

http://paramquery.com/pro/demos - Inline editing - editors & validation (for example, which I have working locally).

If I click in an orderdate cell and select a new date the cell content is updated fine but the UX isn't great / as per http://jqueryui.com/datepicker as the datepicker pops up again rather than remaining hidden.

Suggestions as to how this better (?) UX could be realised in the context of the grid welcome.

Thanks.