Hey Community,
I'm stuck with problem trying to apply detail business rule on my edit grid. So the problem that business rule is looking to UsrParent.UsrStatus column. And i have the error that this column was deleted or renamed.
I've tried some solutions on Community but nothing is working for me.
Here is my code:
methods: { onActiveRowAction: function(buttonTag, primaryColumnValue) { this.mixins.ConfigurationGridUtilitiesV2.onActiveRowAction.call(this, buttonTag, primaryColumnValue); }, generateActiveRowControlsConfig: function(id, columnsConfig, rowConfig) { //var gridDataColumns = getGridDataColumns(); this.columnsConfig = columnsConfig; var gridLayoutItems = []; var currentColumnIndex = 0; this.Terrasoft.each(columnsConfig, function(columnConfig) { var cellConfig = this.getActiveRowCellConfig(columnConfig, currentColumnIndex); if (!cellConfig.hasOwnProperty("isNotFound")) { gridLayoutItems.push(cellConfig); } currentColumnIndex += cellConfig.layout.colSpan; }, this); this.applyBusinessRulesForActiveRow(id, gridLayoutItems); var viewGenerator = this.Ext.create(this.getRowViewGeneratorClassName()); viewGenerator.viewModelClass = this; var gridLayoutConfig = viewGenerator.generateGridLayout({ name: this.name, items: gridLayoutItems }); rowConfig.push(gridLayoutConfig); }, getGridDataColumns: function() { var baseGridDataColumns = this.callParent(arguments); var gridDataColumns = { "UsrParent.UsrStatus": {path: "UsrParent.UsrStatus"}, }; return Ext.apply(baseGridDataColumns, gridDataColumns); } },
thanks!
Like
5 comments
11:03 Sep 12, 2023
Hi,
Do you add this business rule to the grid schema or to the detail edit page schema? Business rules added to the edit page should work properly without this error.
Alternatively try this approach with lookupListConfig in either grid schema and edit page schema of the detail (added to the schema attributes):
"UsrParent": { "dataValueType": this.Terrasoft.DataValueType.LOOKUP, "lookupListConfig": { "columns": ["UsrStatus"] } },
this should also get the value (and load itself) of the UsrStatus column.
11:33 Sep 12, 2023
Oleg Drobina,
Hi!
Thanks for ur answer, i already tried this one added in schema detail/page and still the same issue.
Also copied business-rules from page to detail schema.
Here is full code for Detail schema
define("RdtSchema670160a3Detail", ["ConfigurationGrid", "ConfigurationGridGenerator", "ConfigurationGridUtilitiesV2"], function() { return { entitySchemaName: "RdtProductionRawProducts", attributes: { "IsEditable": { dataValueType: Terrasoft.DataValueType.BOOLEAN, type: Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN, value: true }, "RdtProduction": { "dataValueType": this.Terrasoft.DataValueType.LOOKUP, "lookupListConfig": { "columns": ["RdtStatus"] } } }, mixins: { ConfigurationGridUtilitiesV2: "Terrasoft.ConfigurationGridUtilitiesV2" }, businessRules: /**SCHEMA_BUSINESS_RULES*/{ "RdtRawProduct": { "a51ae6d8-b23d-4245-a06f-6f81a6a20f0d": { "uId": "a51ae6d8-b23d-4245-a06f-6f81a6a20f0d", "enabled": true, "removed": false, "ruleType": 1, "baseAttributePatch": "RdtType", "comparisonType": 3, "autoClean": false, "autocomplete": false, "type": 0, "value": "0e937c72-3826-40c0-ac62-30d70746cea0", "dataValueType": 10 }, "7864a234-ef49-4a9c-ac19-9967fb5b255a": { "uId": "7864a234-ef49-4a9c-ac19-9967fb5b255a", "enabled": true, "removed": false, "ruleType": 0, "property": 1, "logical": 0, "conditions": [ { "comparisonType": 3, "leftExpression": { "type": 1, "attribute": "RdtProduction", "attributePath": "RdtStatus" }, "rightExpression": { "type": 0, "value": "22c74599-4c04-401e-8dfd-06fde8f8cb81", "dataValueType": 10 } } ] } }, "RdtQuantity": { "00b698f4-7e53-4a6b-804f-3a2f40e7b015": { "uId": "00b698f4-7e53-4a6b-804f-3a2f40e7b015", "enabled": true, "removed": false, "ruleType": 0, "property": 1, "logical": 0, "conditions": [ { "comparisonType": 3, "leftExpression": { "type": 1, "attribute": "RdtProduction", "attributePath": "RdtStatus" }, "rightExpression": { "type": 0, "value": "22c74599-4c04-401e-8dfd-06fde8f8cb81", "dataValueType": 10 } } ] } }, "RdtUnit": { "825f4f2a-f110-4554-9a83-575440727c00": { "uId": "825f4f2a-f110-4554-9a83-575440727c00", "enabled": true, "removed": false, "ruleType": 0, "property": 1, "logical": 0, "conditions": [ { "comparisonType": 3, "leftExpression": { "type": 1, "attribute": "RdtProduction", "attributePath": "RdtStatus" }, "rightExpression": { "type": 0, "value": "22c74599-4c04-401e-8dfd-06fde8f8cb81", "dataValueType": 10 } } ] } }, "RdtAvailableStock": { "843f04c6-f4c7-426c-85f3-5560b2383db5": { "uId": "843f04c6-f4c7-426c-85f3-5560b2383db5", "enabled": true, "removed": false, "ruleType": 0, "property": 1, "logical": 0, "conditions": [ { "comparisonType": 1, "leftExpression": { "type": 1, "attribute": "RdtAvailableStock" } } ] } }, "RdtNotEnoughStock": { "7dccf940-c42c-4b5d-82ab-acff711c7893": { "uId": "7dccf940-c42c-4b5d-82ab-acff711c7893", "enabled": true, "removed": false, "ruleType": 0, "property": 1, "logical": 0, "conditions": [ { "comparisonType": 1, "leftExpression": { "type": 1, "attribute": "RdtProduction" } } ] } } }/**SCHEMA_BUSINESS_RULES*/, methods: { onActiveRowAction: function(buttonTag, primaryColumnValue) { this.mixins.ConfigurationGridUtilitiesV2.onActiveRowAction.call(this, buttonTag, primaryColumnValue); }, generateActiveRowControlsConfig: function(id, columnsConfig, rowConfig) { this.columnsConfig = columnsConfig; var gridLayoutItems = []; var currentColumnIndex = 0; this.Terrasoft.each(columnsConfig, function(columnConfig) { var cellConfig = this.getActiveRowCellConfig(columnConfig, currentColumnIndex); if (!cellConfig.hasOwnProperty("isNotFound")) { gridLayoutItems.push(cellConfig); } currentColumnIndex += cellConfig.layout.colSpan; }, this); this.applyBusinessRulesForActiveRow(id, gridLayoutItems); var viewGenerator = this.Ext.create(this.getRowViewGeneratorClassName()); viewGenerator.viewModelClass = this; var gridLayoutConfig = viewGenerator.generateGridLayout({ name: this.name, items: gridLayoutItems }); rowConfig.push(gridLayoutConfig); } }, diff: /**SCHEMA_DIFF*/[ { "operation": "merge", "name": "DataGrid", "values": { "className": "Terrasoft.ConfigurationGrid", "generator": "ConfigurationGridGenerator.generatePartial", "generateControlsConfig": {"bindTo": "generateActiveRowControlsConfig"}, "changeRow": {"bindTo": "changeRow"}, "unSelectRow": {"bindTo": "unSelectRow"}, "onGridClick": {"bindTo": "onGridClick"}, "activeRowActions": [ { "className": "Terrasoft.Button", "style": this.Terrasoft.controls.ButtonEnums.style.TRANSPARENT, "tag": "save", "markerValue": "save", "imageConfig": {"bindTo": "Resources.Images.SaveIcon"} }, { "className": "Terrasoft.Button", "style": this.Terrasoft.controls.ButtonEnums.style.TRANSPARENT, "tag": "cancel", "markerValue": "cancel", "imageConfig": {"bindTo": "Resources.Images.CancelIcon"} }, { "className": "Terrasoft.Button", "style": this.Terrasoft.controls.ButtonEnums.style.TRANSPARENT, "tag": "card", "markerValue": "card", "imageConfig": {"bindTo": "Resources.Images.CardIcon"} }, { "className": "Terrasoft.Button", "style": Terrasoft.controls.ButtonEnums.style.TRANSPARENT, "tag": "copy", "markerValue": "copy", "imageConfig": {"bindTo": "Resources.Images.CopyIcon"} }, { "className": "Terrasoft.Button", "style": this.Terrasoft.controls.ButtonEnums.style.TRANSPARENT, "tag": "remove", "markerValue": "remove", "imageConfig": {"bindTo": "Resources.Images.RemoveIcon"} } ], "initActiveRowKeyMap": {"bindTo": "initActiveRowKeyMap"}, "activeRowAction": {"bindTo": "onActiveRowAction"}, "multiSelect": {"bindTo": "MultiSelect"} } } ]/**SCHEMA_DIFF*/ }; });
Maybe u have other ideas?
Much thanks!
Oleksii
11:46 Sep 12, 2023
Oleksii Protsiuk,
Ok, and can you please point me to the business rule from your code that references the UsrParent.UsrStatus column (or is it RdtStatus in the code above)? And also please share the edit page code.
11:51 Sep 12, 2023
Oleg Drobina,
1. Business rule for RdtQuantity for example.
2. Yes, its RdtStatus.
3.
define("RdtSchemafaf34ef3Page", [], function() { return { entitySchemaName: "RdtProductionRawProducts", attributes: { "RdtProduction": { "dataValueType": this.Terrasoft.DataValueType.LOOKUP, "lookupListConfig": { "columns": ["RdtStatus"] } } }, modules: /**SCHEMA_MODULES*/{}/**SCHEMA_MODULES*/, details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/, businessRules: /**SCHEMA_BUSINESS_RULES*/{ "RdtRawProduct": { "a51ae6d8-b23d-4245-a06f-6f81a6a20f0d": { "uId": "a51ae6d8-b23d-4245-a06f-6f81a6a20f0d", "enabled": true, "removed": false, "ruleType": 1, "baseAttributePatch": "RdtType", "comparisonType": 3, "autoClean": false, "autocomplete": false, "type": 0, "value": "0e937c72-3826-40c0-ac62-30d70746cea0", "dataValueType": 10 }, "7864a234-ef49-4a9c-ac19-9967fb5b255a": { "uId": "7864a234-ef49-4a9c-ac19-9967fb5b255a", "enabled": true, "removed": false, "ruleType": 0, "property": 1, "logical": 0, "conditions": [ { "comparisonType": 3, "leftExpression": { "type": 1, "attribute": "RdtProduction", "attributePath": "RdtStatus" }, "rightExpression": { "type": 0, "value": "22c74599-4c04-401e-8dfd-06fde8f8cb81", "dataValueType": 10 } } ] } }, "RdtQuantity": { "00b698f4-7e53-4a6b-804f-3a2f40e7b015": { "uId": "00b698f4-7e53-4a6b-804f-3a2f40e7b015", "enabled": true, "removed": false, "ruleType": 0, "property": 1, "logical": 0, "conditions": [ { "comparisonType": 3, "leftExpression": { "type": 1, "attribute": "RdtProduction", "attributePath": "RdtStatus" }, "rightExpression": { "type": 0, "value": "22c74599-4c04-401e-8dfd-06fde8f8cb81", "dataValueType": 10 } } ] } }, "RdtUnit": { "825f4f2a-f110-4554-9a83-575440727c00": { "uId": "825f4f2a-f110-4554-9a83-575440727c00", "enabled": true, "removed": false, "ruleType": 0, "property": 1, "logical": 0, "conditions": [ { "comparisonType": 3, "leftExpression": { "type": 1, "attribute": "RdtProduction", "attributePath": "RdtStatus" }, "rightExpression": { "type": 0, "value": "22c74599-4c04-401e-8dfd-06fde8f8cb81", "dataValueType": 10 } } ] } }, "RdtAvailableStock": { "843f04c6-f4c7-426c-85f3-5560b2383db5": { "uId": "843f04c6-f4c7-426c-85f3-5560b2383db5", "enabled": true, "removed": false, "ruleType": 0, "property": 1, "logical": 0, "conditions": [ { "comparisonType": 1, "leftExpression": { "type": 1, "attribute": "RdtAvailableStock" } } ] } }, "RdtNotEnoughStock": { "7dccf940-c42c-4b5d-82ab-acff711c7893": { "uId": "7dccf940-c42c-4b5d-82ab-acff711c7893", "enabled": true, "removed": false, "ruleType": 0, "property": 1, "logical": 0, "conditions": [ { "comparisonType": 1, "leftExpression": { "type": 1, "attribute": "RdtProduction" } } ] } } }/**SCHEMA_BUSINESS_RULES*/, methods: {}, dataModels: /**SCHEMA_DATA_MODELS*/{}/**SCHEMA_DATA_MODELS*/, diff: /**SCHEMA_DIFF*/[ { "operation": "insert", "name": "LOOKUPa8ab8309-ec3e-4f7b-b007-af2483101fee", "values": { "layout": { "colSpan": 12, "rowSpan": 1, "column": 0, "row": 0, "layoutName": "Header" }, "bindTo": "RdtRawProduct", "enabled": false, "contentType": 5 }, "parentName": "Header", "propertyName": "items", "index": 0 }, { "operation": "insert", "name": "LOOKUPe030f444-90d1-4d98-b476-b4b576c4f122", "values": { "layout": { "colSpan": 12, "rowSpan": 1, "column": 12, "row": 0, "layoutName": "Header" }, "bindTo": "RdtUnit", "enabled": false, "contentType": 5 }, "parentName": "Header", "propertyName": "items", "index": 1 }, { "operation": "insert", "name": "FLOAT07d52071-3119-4f71-a45f-3e8701a3e127", "values": { "layout": { "colSpan": 12, "rowSpan": 1, "column": 0, "row": 1, "layoutName": "Header" }, "bindTo": "RdtQuantity", "enabled": false }, "parentName": "Header", "propertyName": "items", "index": 2 }, { "operation": "insert", "name": "RdtAvailableStockbd49a463-5f7d-4a67-aaa6-f01f7cca4cd9", "values": { "layout": { "colSpan": 12, "rowSpan": 1, "column": 12, "row": 1, "layoutName": "Header" }, "bindTo": "RdtAvailableStock", "enabled": false }, "parentName": "Header", "propertyName": "items", "index": 3 }, { "operation": "insert", "name": "RdtNotEnoughStockb7a3c879-7054-4bf6-8434-adb226c77730", "values": { "layout": { "colSpan": 12, "rowSpan": 1, "column": 0, "row": 2, "layoutName": "Header" }, "bindTo": "RdtNotEnoughStock", "enabled": false }, "parentName": "Header", "propertyName": "items", "index": 4 } ]/**SCHEMA_DIFF*/ }; });
11:21 Sep 13, 2023
The same problem with setting the value of the field using connected entity column on the different detail.
1. The field value is showing on field
2. After save the same error and the field is empty.
Is there any chance to fix this error ?
Thanks!
Show all comments