Show Posts

1

Help for ParamQuery Grid (free version) / Re: pq_detail expand on new row

« on: February 16, 2018, 04:23:11 am »

Do you need anymore information to help with this problem?

2

Help for ParamQuery Grid (free version) / pq_detail expand on new row

« on: February 08, 2018, 10:01:04 am »

Hi I have a nested detail grid which does not show and expand when adding a new row to the grid. See below how I add a new row to the grid at the top.
I press a button in the main grid toolbar ( + New Leave) which adds the blank row but does not display the expand detail grid in the detail cell.

var rowData = { Visible: true, IncludeOracleExport: true, IncludeTimesheetReport: true, IncludeForceAbsent: true }; //empty row

var rowIndx = this.addRow({ rowData: rowData, checkEditable: true, rowIndx: 0 });
this.goToPage({ rowIndx: rowIndx });
this.editFirstCellInRow({ rowIndx: rowIndx });
rowData['pq_detail'] = { 'show': true };

this is my definition of the detail cell in my main grid

{ title: "EBA's", minWidth: 50, type: "detail", resizable: false, editable: false }

This is my detailModel definition in my main grid.

detailModel: {
cache: true,
collapseIcon: "ui-icon-plus",
expandIcon: "ui-icon-minus",

init: function (ui) {
var rowData = ui.rowData,
EBAobj = gridPayTypeEBA($PayType, rowData), //get a copy of gridPaytypeEBA
$grid = $("<div></div>").pqGrid(EBAobj); //init the detail grid.

return $grid;
}
}

3

ParamQuery Pro Evaluation Support / Re: datepicker and save button in 1 cell.

« on: August 04, 2017, 05:57:49 am »

I guess this is not possible with your system?

4

ParamQuery Pro Evaluation Support / Re: datepicker and save button in 1 cell.

« on: July 31, 2017, 05:45:50 am »

is it also possible to have a button in the cell at the same time?

5

ParamQuery Pro Evaluation Support / Re: datepicker and save button in 1 cell.

« on: July 28, 2017, 04:04:10 am »

surely there is an easy solution in PQGrid to have a datepicker and a save button in the 1 cell for a whole column?

6

ParamQuery Pro Evaluation Support / Filters not working together

« on: July 26, 2017, 05:54:18 am »

Hi, I have 2 different filters on the one grid, a filter in the toolbar and filters in the column headers. I initially set a column filter to true to display all rows that are visible which works great. When I then use the filter in the toolbar it works to filter, but the column filter seems to not be working as it hen displays all rows that are set to visible and not visible even though the column header filter is set to true to only show visible rows. some code below.

------Column filter code----------

{
title: "<ins><b>Visible?</b></ins>", minWidth: 70, dataIndx: "Visible", type: 'checkbox', dataType: 'bool', filter: {
type: "select",
value: ['true'],
on: true,
condition: 'equal',
prepend: { '': '-ALL-' },
valueIndx: "Visible",
labelIndx: "Visible",
listeners: ['change']
}
}

------Toolbar filter code----------

function filterhandler(evt, ui) {

var $toolbar = $gridEmployee.find('.pq-toolbar-search'),
$value = $toolbar.find(".filterValue"),
value = $value.val(),
condition = $toolbar.find(".filterCondition").val(),
dataIndx = $toolbar.find(".filterColumn").val(),
filterObject;

if (dataIndx == "") {//search through all fields when no field selected.
filterObject = [];
var CM = $gridEmployee.pqGrid("getColModel");
for (var i = 0, len = CM.length; i < len; i++) {
var dataIndx = CM.dataIndx;
filterObject.push({ dataIndx: dataIndx, condition: condition, value: value });
}
}
else {//search through selected field.
filterObject = [{ dataIndx: dataIndx, condition: condition, value: value }];
}
$gridEmployee.pqGrid("filter", {
oper: 'replace',
data: filterObject
});
}

//filterRender to highlight matching cell text.
function filterRender(ui) {
var val = ui.cellData,
filter = ui.column.filter;
if (filter && filter.on && filter.value) {
var condition = filter.condition,
valUpper = val.toUpperCase(),
txt = filter.value,
txt = (txt == null) ? "" : txt.toString(),
txtUpper = txt.toUpperCase(),
indx = -1;
if (condition == "end") {
indx = valUpper.lastIndexOf(txtUpper);
//if not at the end
if (indx + txtUpper.length != valUpper.length) {
indx = -1;
}
}
else if (condition == "contain") {
indx = valUpper.indexOf(txtUpper);
}
else if (condition == "begin") {
indx = valUpper.indexOf(txtUpper);
//if not at the beginning.
if (indx > 0) {
indx = -1;
}
}
if (indx >= 0) {
var txt1 = val.substring(0, indx);
var txt2 = val.substring(indx, indx + txt.length);
var txt3 = val.substring(indx + txt.length);
return txt1 + "<span style='background:yellow;color:#333;'>" + txt2 + "</span>" + txt3;
}
else {
return val;
}
}
else {
return val;
}
}

toolbar: {
cls: "pq-toolbar-search",
items: [{
type: 'textbox',
label: 'Filter: ',
attr: 'placeholder="Enter your keyword"',
cls: "filterValue",
listener: { keyup: filterhandler }
},
{
type: 'select', cls: "filterColumn",
listener: filterhandler,
options: function (ui) {
var CM = ui.colModel;
var opts = [{}];// [{ '': '[ All Fields ]' }];
var obj1 = {};
obj1[CM[2].dataIndx] = CM[2].title;
obj1[CM[1].dataIndx] = CM[1].title;
obj1[CM[0].dataIndx] = CM[0].title;
opts.push(obj1);
obj1 = null;
for (var i = 3; i < CM.length; i++) {
var column = CM;
var obj = {};

if (column.hidden != true) {
obj[column.dataIndx] = column.title;
opts.push(obj);
}
}
return opts;
}
},
{
type: 'select',
cls: "filterCondition",
listener: filterhandler,
options: [
{ "begin": "Begins With" },
{ "contain": "Contains" },
{ "end": "Ends With" },
{ "notcontain": "Does not contain" },
{ "equal": "Equal To" },
{ "notequal": "Not Equal To" },
{ "empty": "Empty" },
{ "notempty": "Not Empty" },
{ "less": "Less Than" },
{ "great": "Great Than" },
{ "regexp": "Regex" }
]
}, {
type: 'button', icon: 'ui-icon-plus', label: '<h3 style="color:green;">New Employee</h3>', listener: function () {
//append empty row at the end.
var rando = randomStr();
var rowData = { Visible: true, ID: rando }; //empty row

//var rowIndx = this.addRow({ rowData: rowData, checkEditable: true });
try {
var rowIndx = this.addRow({ rowData: rowData, checkEditable: true, rowIndx: 0 });
this.goToPage({ rowIndx: rowIndx });
this.editFirstCellInRow({ rowIndx: rowIndx });
}
catch (err) {
alert(err);
}
}
},
{ type: 'button', label: '<h3 style="color:red;">Delete Employee</h3>', listeners: [{ click: deleteEmployeeRow }], icon: 'ui-icon-minus' },
{
type: 'button',
cls: 'blue',
icon: 'ui-icon-pencil',
label: '<h3 style="color:blue;"><b>Save All Updated Rows</b></h3>',
options: { disabled: false },
listener: function () {
saveChanges(this);
}
},
{
type: 'button',
icon: 'ui-icon-arrowrefresh-1-s',
label: '<h3 style="color:grey;"><b>Refresh Grid</b></h3>',
options: { disabled: false },
listener: function () {
this.refreshDataAndView();
}
}]
}

7

ParamQuery Pro Evaluation Support / datepicker and save button in 1 cell.

« on: July 26, 2017, 05:32:18 am »

I want to show a datepicker and a button in 1 cell for the whole column? How can I do this?

8

ParamQuery Pro Evaluation Support / Validation

« on: June 06, 2017, 04:28:47 am »

When pasting in data into a grid, I have a few select editor drop down boxes. How do I get the grid to display an invalid message in a row if the data being pasted in does not exist in one of the select editor drop down boxes?

9

ParamQuery Pro Evaluation Support / Re: Focus on Grid body

« on: June 06, 2017, 03:51:54 am »

any idea? I am trying to do a paste event into the grid after pressing a button in the toolbar.

10

ParamQuery Pro Evaluation Support / Focus on Grid body

« on: June 02, 2017, 09:15:49 am »

How do I point the focus of the grid to the rows, after a button press in the toolbar (ie. focus to body of grid with no rows), I was then thinking of running a command similar to this to paste data which creates rows.

var e = jQuery.Event("keydown");
e.which = 86;
e.ctrlKey = true;
$("input").trigger(e);

I am guessing I would need to change this line to point the focus to the grid rows $("input").trigger(e); to something like this? $("#grid_json_employeeBulk").pqGrid.trigger(e);

11

ParamQuery Pro Evaluation Support / pgGrid on multiple pages

« on: May 30, 2017, 04:11:02 am »

In the 1 website project in Visual studio, pq.grid in the demo PRO version does not seem to work when you try to add it to 2 or more webpages, it only works on the 1st page you add it. Is this a restriction in the DEMO PRO version or will it not also work on multiple pages in the bought version also? I declare the JQuery and paramquery links in a master page. It is like the pq does not exist on the 2nd page etc.

12

ParamQuery Pro Evaluation Support / Re: change cell value after editor -> select has changed

« on: April 20, 2017, 10:18:07 am »

do you need more information???

13

ParamQuery Pro Evaluation Support / Re: Crosstab query with dynamic columns

« on: April 13, 2017, 05:08:42 am »

This is my column array below, is there a way that I can add a function to the "hidden" element in the column to decide if it is true or false, it will be whether the columns titles from 104, 105 etc. onwards are in the actual data?

var columnsDetail = [

{
title: "DisplayCols", dataType: "string", dataIndx: "DisplayCols", editable: false, hidden: true
},
{
title: "RecID", dataType: "string", dataIndx: "RecID", editable: false, hidden: true
},
{
title: "EmployeeId", dataType: "integer", dataIndx: "EmployeeId", editable: false, hidden: true
},

{
title: "Employee", dataType: "string", editable: false, dataIndx: "Employee", minWidth: 140, maxWidth: 180, hidden: false,
filter: {
type: "select",
condition: 'equal',
prepend: { '': '-ALL-' },
valueIndx: "Employee",
labelIndx: "Employee",
listeners: ['change']
}
},
{
title: "Emp. No.", dataType: "string", editable: false, dataIndx: "EmployeeNo", minWidth: 70, maxWidth: 70, hidden: false, filter: {
type: "select",
condition: 'equal',
prepend: { '': '-ALL-' },
valueIndx: "EmployeeNo",
labelIndx: "EmployeeNo",
listeners: ['change']
}
},
{
title: "Trade", dataType: "string", editable: false, dataIndx: "TradeName", minWidth: 130, maxWidth: 200, hidden: false, filter: {
type: "select",
condition: 'equal',
prepend: { '': '-ALL-' },
valueIndx: "TradeName",
labelIndx: "TradeName",
listeners: ['change']
}
},
{
title: "Contract", dataType: "string", editable:false, dataIndx: "ContractNo", minWidth: 70, maxWidth: 70, hidden: false, filter: {
type: "select",
condition: 'equal',
prepend: { '': '-ALL-' },
valueIndx: "ContractNo",
labelIndx: "ContractNo",
listeners: ['change']
}
},
{
title: "W.O", dataType: "string", dataIndx: "WorkOrderNumber", minWidth: 90, hidden: false, editable: function (ui) { if (ui.rowData.Update == 1) { return true; } else { return false; } },
filter: {
type: "select",
condition: 'equal',
prepend: { '': '-ALL-' },
valueIndx: "WorkOrderNumber",
labelIndx: "WorkOrderNumber",
listeners: ['change']
},
editor: {
type: 'select',
valueIndx: "WorkOrderNo",
labelIndx: "WorkOrderNo",
options: []
},
validations: [{ type: 'minLen', value: 1, msg: "Required" }]
},
{
title: "Event", dataType: "string", dataIndx: "Event", minWidth: 70, maxWidth: 70, hidden: false, editable: function (ui) { if (ui.rowData.Update == 1) { return true; } else { return false; } },
filter: {
type: "select",
condition: 'equal',
prepend: { '': '-ALL-' },
valueIndx: "Event",
labelIndx: "Event",
listeners: ['change']
},
editor: {
type: 'select',
prepend: { "": "" },
options: function (ui) {
var id = ui.rowData.WorkOrderNumber;

var eventList = "";
//iterate through the events list to find the matching record.
for (var i = 0; i < EventDD.length; i++) {

var row = EventDD;
if (row.WorkOrderNo == id) {//match found.
eventList = eventList + "|" + row.EventNo;
}
}
if (eventList.length == 0) {
return [];
}
else {
return eventList.split("|");
}
}
}
},
{
title: "S.I", dataType: "string", dataIndx: "SI", minWidth: 70, maxWidth: 80, hidden: false, editable: function (ui) { if (ui.rowData.Update == 1) { return true; } else { return false; } }, filter: {
type: "select",
condition: 'equal',
prepend: { '': '-ALL-' },
valueIndx: "SI",
labelIndx: "SI",
listeners: ['change']
},
editor: {
type: 'select',
prepend: { "": "" },
options: function (ui) {
var id = ui.rowData.WorkOrderNumber;

var SIList = "";
//iterate through the events list to find the matching record.
for (var i = 0; i < SIDD.length; i++) {

var row = SIDD;
if (row.VariationNo == id) {//match found.
SIList = SIList + "|" + row.SINo;
}
}
if (SIList.length == 0) {
return [];
}
else {
return SIList.split("|");
}
}
}
},
{
title: "SWS", dataType: "string", dataIndx: "SWS", minWidth: 70, maxWidth: 70, hidden: false, editable: function (ui) { if (ui.rowData.Update == 1) { return true; } else { return false; } }, filter: {
type: "select",
condition: 'equal',
prepend: { '': '-ALL-' },
valueIndx: "SWS",
labelIndx: "SWS",
listeners: ['change']
}
},
{
title: "Date", dataType: "date", dataIndx: "TimesheetDate", minWidth: 60, maxWidth: 60, hidden: false, editable: function (ui) { if (ui.rowData.Update == 1) { return true; } else { return false; } },
editor: {
type: 'textbox',
init: dateEditor
},
validations: [
{ type: 'regexp', value: '^[0-9]{2}/[0-9]{2}/[0-9]{2}$', msg: 'Not in dd/mm/yy format' }
]
},
{
title: "Comments", dataType: "string", dataIndx: "Comments", minWidth: 100, hidden: false, editable: function (ui) { if (ui.rowData.Update == 1) {return true;} else {return false;} }
},
{
title: "", dataIndx: "Delete", minWidth: 80, maxWidth: 80, hidden: false, editable: false,
render: function (ui) {
if (ui.rowData.Delete != null) {
if (ui.rowData.Delete == 1) {
return "<button type='button' class='delete_btn' style='font-weight: bold; color: #FF0000'>Delete</button>";
}
else {
return "<button type='button' disabled='disabled' style='font-weight: bold; color: #FFFFFF'>Delete</button>";
}
}
},
postRender: function (ui) {
var grid = this,
$cell = grid.getCell(ui);
$cell.find("button").button({ icons: { primary: 'ui-icon-scissors' } })
.bind("click", function () {
deleteRow(grid, ui.rowData.Employee, ui.rowData.EmployeeId, ui.rowData.WorkOrderNumber, ui.rowData.Event, ui.rowData.SI, ui.rowData.SWS, ui.rowData.TimesheetDate, ui.rowData.Comments, querySt('Login'));
});
}
},
{ title: "NT", dataType: "float", dataIndx: "NT", minWidth: 40, maxWidth: 40, editable: true },
{ title: "TH", dataType: "float", dataIndx: "TH", minWidth: 38, maxWidth: 38, editable: true },
{ title: "DT", dataType: "float", dataIndx: "DT", minWidth: 38, maxWidth: 38, editable: true },
{ title: "102", dataType: "float", dataIndx: "102", minWidth: 38, maxWidth: 38, editable: true },
{ title: "104", dataType: "float", dataIndx: "_104", minWidth: 38, maxWidth: 38, editable: true },
{ title: "105", dataType: "float", dataIndx: "_105", minWidth: 38, maxWidth: 38, editable: true },
{ title: "106", dataType: "float", dataIndx: "_106", minWidth: 38, maxWidth: 38, editable: true },
{ title: "107", dataType: "float", dataIndx: "_107", minWidth: 38, maxWidth: 38, editable: true },
{ title: "109", dataType: "float", dataIndx: "_109", minWidth: 38, maxWidth: 38, editable: true },
{ title: "110", dataType: "float", dataIndx: "_110", minWidth: 38, maxWidth: 38, editable: true },
{ title: "112", dataType: "float", dataIndx: "_112", minWidth: 38, maxWidth: 38, editable: true },
{ title: "113", dataType: "float", dataIndx: "_113", minWidth: 38, maxWidth: 38, editable: true },
{ title: "115", dataType: "float", dataIndx: "_115", minWidth: 38, maxWidth: 38, editable: true },
{ title: "120", dataType: "float", dataIndx: "_120", minWidth: 38, maxWidth: 38, editable: true },
{ title: "128", dataType: "float", dataIndx: "_128", minWidth: 38, maxWidth: 38, editable: true },
{ title: "129", dataType: "float", dataIndx: "_129", minWidth: 38, maxWidth: 38, editable: true },
{ title: "131", dataType: "float", dataIndx: "_131", minWidth: 38, maxWidth: 38, editable: true },
{ title: "132", dataType: "float", dataIndx: "_132", minWidth: 38, maxWidth: 38, editable: true },
{ title: "135", dataType: "float", dataIndx: "_135", minWidth: 38, maxWidth: 38, editable: true },
{ title: "140", dataType: "float", dataIndx: "_140", minWidth: 38, maxWidth: 38, editable: true },
{ title: "145", dataType: "float", dataIndx: "_145", minWidth: 38, maxWidth: 38, editable: true },
{ title: "146", dataType: "float", dataIndx: "_146", minWidth: 38, maxWidth: 38, editable: true },
{ title: "147", dataType: "float", dataIndx: "_147", minWidth: 38, maxWidth: 38, editable: true },
{ title: "148", dataType: "float", dataIndx: "_148", minWidth: 38, maxWidth: 38, editable: true },
{ title: "150", dataType: "float", dataIndx: "_150", minWidth: 38, maxWidth: 38, editable: true },
{ title: "151", dataType: "float", dataIndx: "_151", minWidth: 38, maxWidth: 38, editable: true },
{ title: "152", dataType: "float", dataIndx: "_152", minWidth: 38, maxWidth: 38, editable: true },
{ title: "155", dataType: "float", dataIndx: "_155", minWidth: 38, maxWidth: 38, editable: true },
{ title: "156", dataType: "float", dataIndx: "_156", minWidth: 38, maxWidth: 38, editable: true },
{ title: "160", dataType: "float", dataIndx: "_160", minWidth: 38, maxWidth: 38, editable: true },
{ title: "161", dataType: "float", dataIndx: "_161", minWidth: 38, maxWidth: 38, editable: true },
{ title: "161a", dataType: "float", dataIndx: "_161a", minWidth: 38, maxWidth: 38, editable: true },
{ title: "164", dataType: "float", dataIndx: "_164", minWidth: 38, maxWidth: 38, editable: true },
{ title: "168", dataType: "float", dataIndx: "_168", minWidth: 38, maxWidth: 38, editable: true },
{ title: "168a", dataType: "float", dataIndx: "_169a", minWidth: 38, maxWidth: 38, editable: true },
{ title: "170", dataType: "float", dataIndx: "_170", minWidth: 38, maxWidth: 38, editable: true },
{ title: "178", dataType: "float", dataIndx: "_178", minWidth: 38, maxWidth: 38, editable: true },
{ title: "180", dataType: "float", dataIndx: "_180", minWidth: 38, maxWidth: 38, editable: true },
{ title: "187", dataType: "float", dataIndx: "_187", minWidth: 38, maxWidth: 38, editable: true },
{ title: "188", dataType: "float", dataIndx: "_188", minWidth: 38, maxWidth: 38, editable: true },
{ title: "189", dataType: "float", dataIndx: "_189", minWidth: 38, maxWidth: 38, editable: true },
{ title: "196", dataType: "float", dataIndx: "_196", minWidth: 38, maxWidth: 38, editable: true },
{ title: "202", dataType: "float", dataIndx: "_202", minWidth: 38, maxWidth: 38, editable: true },
{ title: "210", dataType: "float", dataIndx: "_210", minWidth: 38, maxWidth: 38, editable: true },
{ title: "211", dataType: "float", dataIndx: "_211", minWidth: 38, maxWidth: 38, editable: true }
];

14

ParamQuery Pro Evaluation Support / Re: Crosstab query with dynamic columns

« on: April 11, 2017, 09:28:50 am »

where do I run this code exactly at runtime as I cannot get it to work? This is my current code on creating the grid.

var dataModelDetail = {
location: "remote",
dataType: "json",
method: "GET",
recIndx: "RecID", //used to make update row active
url: "http://projectcontrols/TimeLinkWebservice/TimeLinkWebservice.asmx/JSON_TimesheetDetail?projectID=" + querySt("ProjectID") + "&managerID=" + document.getElementById("<%=ddlManager.ClientID %>").value + "&FromDate=" + fdate[1] + '/' + fdate[0] + '/' + fdate[2] + "&ToDate=" + tdate[1] + '/' + tdate[0] + '/' + tdate[2] + "&EmployeeName=",
success: function (result) {
$('#grid_jsonpDetail').html(result);
},
error: function (jq) {
alert(JSON.stringify(jq));
},
getData: function (dataJSON) {
var data = dataJSON.data;
return { curPage: dataJSON.curPage, totalRecords: dataJSON.totalRecords, data: data };
},
};

var objDetail = {
load: function () {
var grid = this;
var filter = grid.getColumn({ dataIndx: "TradeName" }).filter;
filter.cache = null;
filter.options = grid.getData({ dataIndx: ["TradeName"] });

filter = grid.getColumn({ dataIndx: "Employee" }).filter;
filter.cache = null;
filter.options = grid.getData({ dataIndx: ["Employee"] });

filter = grid.getColumn({ dataIndx: "EmployeeNo" }).filter;
filter.cache = null;
filter.options = grid.getData({ dataIndx: ["EmployeeNo"] });

filter = grid.getColumn({ dataIndx: "WorkOrderNumber" }).filter;
filter.cache = null;
filter.options = grid.getData({ dataIndx: ["WorkOrderNumber"] });

filter = grid.getColumn({ dataIndx: "ContractNo" }).filter;
filter.cache = null;
filter.options = grid.getData({ dataIndx: ["ContractNo"] });

filter = grid.getColumn({ dataIndx: "Event" }).filter;
filter.cache = null;
filter.options = grid.getData({ dataIndx: ["Event"] });

filter = grid.getColumn({ dataIndx: "SI" }).filter;
filter.cache = null;
filter.options = grid.getData({ dataIndx: ["SI"] });

filter = grid.getColumn({ dataIndx: "SWS" }).filter;
filter.cache = null;
filter.options = grid.getData({ dataIndx: ["SWS"] });
},

width: 1700,
height: 800,
filterModel: { on: true, mode: "AND", header: true },
scrollModel: { autoFit: true },
collapsible: false,
postRenderInterval: -1, //synchronous post render.
pageModel: { type: "local", rPP: 100, rPPOptions: [10, 50, 100, 2000], strRpp: "{0}", strDisplay: "{0} to {1} of {2}" },
dataModel: dataModelDetail,
colModel: columnsDetail,
trackModel: { on: true }, //used to make update row active
create: function (evt, ui) {

var grid = this,
column;

this.option('dataModel.data', dataModelDetail);
this.refreshCM(columnsDetail); //assign new colModel.
this.refreshDataAndView();

//fetch options for WO column from server.
var ContractNo = '%';
$.getJSON("http://projectcontrols/TimeLinkWebservice/TimeLinkWebservice.asmx/JSON_GetWOs?SupervisorID=" + document.getElementById("<%=ddlManager.ClientID %>").value + "&WorkOrderNo=&projectID=" + querySt("ProjectID") + "&ContractNo=" + ContractNo + "&IncludeLeave=True", function (response) {

column = grid.getColumn({ dataIndx: 'WorkOrderNumber' });
column.editor.options = response;
});

$.getJSON("http://projectcontrols/TimeLinkWebservice/TimeLinkWebservice.asmx/JSON_GetSIs?WorkOrderNo=%&DateCriteria=" + fdate[1] + '/' + fdate[0] + '/' + fdate[2] + "&ContractNo=" + ContractNo + "&projectID=" + querySt("ProjectID"), function (response) {

SIDD = response;
});

$.getJSON("http://projectcontrols/TimeLinkWebservice/TimeLinkWebservice.asmx/JSON_GetEvents?WorkOrderNo=%&DateCriteria=" + fdate[1] + '/' + fdate[0] + '/' + fdate[2] + "&ContractNo=" + ContractNo + "&projectID=" + querySt("ProjectID"), function (response) {

EventDD = response;
});
},
wrap: true, hwrap: true,
editModel: {
clicksToEdit: 1,
// pressToEdit: $.ui.keyCode.ENTER,
saveKey: $.ui.keyCode.ENTER,
keyUpDown: false,
cellBorderWidth: 0
},
toolbar: {
items: [{
type: 'button',
cls: 'blue',
icon: 'ui-icon-pencil',
label: '<h3 style="color:blue;"><b>Save All Updated Rows</b></h3>',
options: { disabled: false },
listener: function () {
saveChanges(this);
}
}]
},
hoverMode: 'row',
numberCell: { show: false, resizable: true, title: "#" },
title: "<u><b><mark>Detail</mark></b></u>",
resizable: true
};

var $gridDetail = pq.grid("#grid_jsonpDetail", objDetail);

15

ParamQuery Pro Evaluation Support / change cell value after editor -> select has changed

« on: April 11, 2017, 08:51:16 am »

How do I make a different cell in the same row automatically change to blank when I select a new value from the editor.

editor: {
type: 'select',
valueIndx: "WorkOrderNo",
labelIndx: "WorkOrderNo",
options: []
}

Messages - daverene

Help for ParamQuery Grid (free version) / Re: pq_detail expand on new row

Help for ParamQuery Grid (free version) / pq_detail expand on new row

ParamQuery Pro Evaluation Support / Re: datepicker and save button in 1 cell.

ParamQuery Pro Evaluation Support / Re: datepicker and save button in 1 cell.

ParamQuery Pro Evaluation Support / Re: datepicker and save button in 1 cell.

ParamQuery Pro Evaluation Support / Filters not working together

ParamQuery Pro Evaluation Support / datepicker and save button in 1 cell.

ParamQuery Pro Evaluation Support / Validation

ParamQuery Pro Evaluation Support / Re: Focus on Grid body

ParamQuery Pro Evaluation Support / Focus on Grid body

ParamQuery Pro Evaluation Support / pgGrid on multiple pages

ParamQuery Pro Evaluation Support / Re: change cell value after editor -> select has changed

ParamQuery Pro Evaluation Support / Re: Crosstab query with dynamic columns

ParamQuery Pro Evaluation Support / Re: Crosstab query with dynamic columns

ParamQuery Pro Evaluation Support / change cell value after editor -> select has changed