Messages

1

Help for ParamQuery Pro / Re: Getting all checked checkboxes externally

« on: November 19, 2018, 10:19:59 pm »

Ok, so for anyone wondering, the method to call this function outside of the grid is as follows:

Code: [Select]

$grid.pqGrid("Checkbox", "state");

2

Help for ParamQuery Pro / Getting all checked checkboxes externally

« on: November 19, 2018, 10:15:32 pm »

Hello,

I have checkboxes in a column called 'state', and I have a button below my grid that fetches all the ticked checkboxes.

However, this function does not work (it says "Uncaught TypeError: $(...).Checkbox is not a function"):

Code: [Select]

function getChecked() {
var boxes = $("#grid").Checkbox('state');
}

What is the correct way to access the Checkbox object when using an external button please?

Thank you,
Seb

3

Help for ParamQuery Pro / Re: Export date type fields

« on: November 16, 2018, 09:01:40 pm »

Hi,

My column model looks like this:

Code: [Select]

colModel: [
{ title: "Date Added", width: 100, dataType: "date", dataIndx: "date_of", format: "dd/mm/yy" }
]

My export code looks like this:

Code: [Select]

function exportGrid() {
var blob = $grid.pqGrid("exportData", {
url: "/api/excel/export.php",
format: "xlsx",
render: true,
type: "blob",
filename: "export",
sheetName: "Export"
});
}

But when I open the Excel file, the date has come through as a string, and I have to manually convert it to a date by couble-clicking in the cell.

Thanks,
Seb

4

Bug Report / exportData event

« on: November 16, 2018, 04:33:37 pm »

Hello,

In ParamQuery 5.5.0, I'm finding that the exportData event is not being triggered after an export. Here is how I perform an export:

Code: [Select]

function exportGrid() {
var blob = $grid.pqGrid("exportData", {
url: "/api/excel/export.php",
format: "xlsx",
render: true,
type: "blob",
filename: "export",
sheetName: "Export"
});
}


5

Help for ParamQuery Pro / Export date type fields

« on: November 16, 2018, 03:33:50 pm »

Hello,

When I export a grid with dates in a column, the dates appear as text in Excel, rather than a true date object. I have set the PQGrid column dataType: "date", so I thought this would have worked.

Please can you advise the correct method for exporting date columns?

Thank you,
Seb

6

Help for ParamQuery Pro / Re: How to use Export Function using FileSaverJs file

« on: November 15, 2018, 09:45:48 pm »

I have included all libraries in my ParamQuery5.5.0 release, but the saveAs() function is undefined.

Also, there is no filesaver.js file in the jsZip-2.5.0 folder anymore.

Thanks,
seb

7

Help for ParamQuery Pro / Re: Get currently selected single row

« on: November 15, 2018, 09:29:27 pm »

Thank you for the clarification. For reference, this is now what works for me to get the currently selected row:

Code: [Select]

var d = $grid.pqGrid("SelectRow").getSelection()[0].rowData;

8

Help for ParamQuery Pro / Get currently selected single row

« on: November 15, 2018, 09:05:35 pm »

Hi,

I'm having real trouble upgrading my code from the free version, to the pro version. I'm stuck on trying to get the currently selected row in a grid. This is my code that used to work with the free version of PQGrid:

Code: [Select]

var d = $grid.pqGrid("selection", {type:'row', method:'getSelection'})[0].rowData;
This no longer works, and seems that the selection array is empty, even though a row is selected. Here is how I initialised the grid:

Code: [Select]

$grid = $("#grid").pqGrid({
colModel: [
{ title: "Client Name", width: 383, dataType: "string", dataIndx: "client_name" }
],
dataModel: {
location: "remote",
dataType: "json",
method: "POST",
postData: getPostData(),
url: "/api/accounts/get_clients.php",
getData: function(d) {
return { data: d.data };
}
},
scrollModel: { autoFit: true },
height: 424,
showTop: false,
showBottom: false,
resizable: false,
editable: false,
numberCell: { show: false },
selectionModel: { type: 'row', mode: 'single' },
hoverMode: 'row'
});
How do I get the currently selected row? (only full, single rows are what are allowed).

Thank you!

9

ParamQuery Pro Evaluation Support / Re: Did not receive paid for version in email

« on: November 13, 2018, 02:27:27 pm »

Thank you! 

10

ParamQuery Pro Evaluation Support / Did not receive paid for version in email

« on: November 13, 2018, 02:18:40 pm »

Hello,

I did not receive my copy of ParamQuery Pro after paying 18 hours ago. My receipt no. xxxx-xxxx-8684-0746.

Please can you let me know how to download this package?

Thank you,
Seb