Yes of course. I have also opened a case with the PTC support (16269082), because I have the issue that my table (specific columns) are not editable even though all necessary settings are set properly. Strangely enough: The support responded that everything works fine and the columns (just checkboxes) are editable. I have tried the sample entities I have send them in multiple browsers and different TWX 9.3.0 instances, but the columns with the checkboxes are staying "disabled" and non editable.
This is my service to create the json config (this service has two string inputs: "orderType" and "orderState"):
// Hide asset columns when orderType is not "Mutterrolle"
const hideAssetSelectionColumns = orderType != 2;
const isAssetSelectionColumnInLayout = !hideAssetSelectionColumns; // InLayout defines if the user can set a column visible at runtime
// Only "Mutterrolle" in state "new" or "planning" is editable
const isEditable = orderType == "2" && (orderState == "2" || orderState == "3");
const editControlVisibility = isEditable ? "hover" : "never";
let gridTitle = "Neue Prozessaufträge";
if (orderState == "2" || orderState == "3") gridTitle = "Geplante Prozessaufträge";
if (orderState == "4") gridTitle = "Fertige Prozessaufträge";
const result = {
"label": {
"label": gridTitle,
"type": "sub-header",
"alignment": "left"
},
"filter": {
"show": false
},
"resizeColumns": false,
"reorderColumns": false,
"columns": {
"idFieldName": "aufnr",
"header": {
"hide": false,
"singleLine": true,
//"maxHeight": 32,
"selectionCheckboxAlignment": "bottom",
"sortSelectionColumn": true,
"overflow": "disclosure" // *{string} header overflow setting. Options: 'fitted', 'wrapped', 'clipped', 'ellipsis'
},
"enableSorting": false, // Optional. Enable sorting capabilities for the grid.
"columnDefs": [
{
"targets": 0, // {integer} the index of the column to which this data applies.
"fieldName": "aufnr", // {string} the data field name.
"title": "Auftrag", // *{string} the column display name.
"autoWidth": true,
"overflow": "wrapped", // *{string} cell overflow setting. Options: 'fitted', 'wrapped', 'clipped', 'ellipsis'
"headerTextAlignment": "left", // *{string} header text alignment. Options: 'left', 'right', 'center'.
"textAlignment": "left", // *{string} cell text alignment. Options: 'left', 'right', 'center'.
"hidden": false, // *{boolean} hide column. If context menu is enabled, end-user can unhide column. Data of this column will be available for state formatting.
"inLayout": true,
"sortable": true,
"columnFormatter": {
"type": "string",
"cellEditor": { // optional: defines cell-editing options for this column
"enabled": false // *{boolean} to indicate whether cell editing is enable for this column
}
}
},
{
"targets": 1,
"fieldName": "matnr",
"title": "Material",
"autoWidth": true,
"overflow": "wrapped",
"headerTextAlignment": "left",
"textAlignment": "left",
"hidden": false,
"inLayout": true,
"sortable": true,
"columnFormatter": {
"type": "string",
"cellEditor": {
"enabled": false
}
}
},
{
"targets": 2,
"fieldName": "matktx",
"title": "Beschreibung",
"autoWidth": true,
"overflow": "wrapped",
"headerTextAlignment": "left",
"textAlignment": "left",
"hidden": false,
"inLayout": true,
"sortable": false,
"columnFormatter": {
"type": "string",
"cellEditor": {
"enabled": false
}
}
},
{
"targets": 3,
"fieldName": "inserttime",
"title": "Import",
"autoWidth": true,
"overflow": "wrapped",
"headerTextAlignment": "left",
"textAlignment": "left",
"hidden": false,
"inLayout": true,
"sortable": true,
"columnFormatter": {
"type": "datetime",
"format":"DD.MM.YYYY - HH:mm:ss",
"cellEditor": {
"enabled": false
}
}
},
{
"targets": 4,
"fieldName": "posnr",
"title": "Position",
"autoWidth": true,
"overflow": "wrapped",
"headerTextAlignment": "center",
"textAlignment": "left",
"hidden": true,
"inLayout": false,
"sortable": false,
"columnFormatter": {
"type": "string",
"cellEditor": {
"enabled": false
}
}
},
{
"targets": 5,
"fieldName": "anlagenstatus",
"title": "Status",
"autoWidth": true,
"overflow": "wrapped",
"headerTextAlignment": "left",
"textAlignment": "left",
"hidden": true,
"inLayout": false,
"sortable": false,
"columnFormatter": {
"type": "string",
"cellEditor": {
"enabled": false
}
}
},
{
"targets": 6,
"fieldName": "aufart",
"title": "Typ",
"autoWidth": true,
"overflow": "wrapped",
"headerTextAlignment": "left",
"textAlignment": "left",
"hidden": true,
"inLayout": false,
"sortable": false,
"columnFormatter": {
"type": "string",
"cellEditor": {
"enabled": false
}
}
},
{
"targets": 7,
"fieldName": "aufstatus",
"title": "Auftragsstatus",
"autoWidth": true,
"overflow": "wrapped",
"headerTextAlignment": "center",
"textAlignment": "left",
"hidden": true,
"inLayout": false,
"sortable": false,
"columnFormatter": {
"type": "string",
"cellEditor": {
"enabled": false,
}
}
},
{
"targets": 8,
"fieldName": "AN2",
"title": "A",
"autoWidth": false,
"width": "50px",
"overflow": "fitted",
"headerTextAlignment": "center",
"textAlignment": "center",
"hidden": hideAssetSelectionColumns,
"inLayout": isAssetSelectionColumnInLayout,
"sortable": false,
"columnFormatter": {
"type": "boolean",
"format": "checkbox",
"cellEditor": {
"enabled": isEditable
}
}
},
{
"targets": 9,
"fieldName": "AN3",
"title": "C",
"autoWidth": false,
"width": "50px",
"overflow": "fitted",
"headerTextAlignment": "center",
"textAlignment": "center",
"hidden": hideAssetSelectionColumns,
"inLayout": isAssetSelectionColumnInLayout,
"sortable": false,
"columnFormatter": {
"type": "boolean",
"format": "checkbox",
"cellEditor": {
"enabled": isEditable
}
}
},
{
"targets": 10,
"fieldName": "AN4",
"title": "D",
"autoWidth": false,
"width": "50px",
"overflow": "none",
"headerTextAlignment": "center",
"textAlignment": "center",
"hidden": hideAssetSelectionColumns,
"inLayout": isAssetSelectionColumnInLayout,
"sortable": false,
"columnFormatter": {
"type": "boolean",
"format": "checkbox",
"cellEditor": {
"enabled": isEditable
}
}
},
{
"targets": 11,
"fieldName": "AN5",
"title": "F",
"autoWidth": false,
"width": "50px",
"overflow": "fitted",
"headerTextAlignment": "center",
"textAlignment": "center",
"hidden": hideAssetSelectionColumns,
"inLayout": isAssetSelectionColumnInLayout,
"sortable": false,
"columnFormatter": {
"type": "boolean",
"format": "checkbox",
"cellEditor": {
"enabled": isEditable
}
}
},
{
"targets": 12,
"fieldName": "AN7",
"title": "B",
"autoWidth": false,
"width": "50px",
"overflow": "fitted",
"headerTextAlignment": "center",
"textAlignment": "center",
"hidden": hideAssetSelectionColumns,
"inLayout": isAssetSelectionColumnInLayout,
"sortable": false,
"columnFormatter": {
"type": "boolean",
"format": "checkbox",
"cellEditor": {
"enabled": isEditable
}
}
},
{
"targets": 13,
"fieldName": "AN8",
"title": "E",
"autoWidth": false,
"width": "50px",
"overflow": "fitted",
"headerTextAlignment": "center",
"textAlignment": "center",
"hidden": hideAssetSelectionColumns,
"inLayout": isAssetSelectionColumnInLayout,
"sortable": false,
"columnFormatter": {
"type": "boolean",
"format": "checkbox",
"cellEditor": {
"enabled": isEditable
}
}
}
]
},
"rows": {
"selection": "single",
"singleLine": true,
},
"editButtons": {
"enabled": isEditable,
"editButton": false,
"editLevel": "row", //* Controls the edit level. Options: "row", "cell", "grid"
"rowDeleteButton": false,
"rowAddButton": false,
"editControlVisibility": "hover", // Controls the visibility of the edit controls on the grid. Options: 'hover', 'always', 'never'}
"editControlType": "icon",
"editControlLabel": "Edit",
}
};
logger.info(JSON.stringify(result));
