- Help!
- I have a table that I will call x_product that extends sc_cat_item. There is a custom field quantityonstock that exists on the x_product table in a scoped app.
- I have not been able to update the field using a script include.
- Currently, quantityonstock is successfully updated via a server side script that's part of a widget and also via a scheduled import and via a backend script. But I need to be able to update it via a script include.
- I know that the code works as I have tested it via backend script.
- I've looked into Application Access, Cross Scope Privileges, Restricted Caller Access, Read-Only on field, ACLs, Don't see any Data policies. Not sure what I'm missing.
___________________________________________________________________
Here's a little more detail with screen shots:
Ultimately, I want to be able to call the Script Include from UI Builder Experience Page via Data Transform Server Side Script.
Current setup is a Fix Script that calls a Script Include in WMS scope
The Script Include is in the same WMS scope but updates a table in another scope. We'll call the scope ABC.
Here's a snippet of the code:
var processInventoryUtility = Class.create();
processInventoryUtility.prototype = {
initialize: function(productSysId, quantity) {
this.qty = parseInt(quantity, 10);
this.productId = productSysId;
},
//Retrieve Record
_retreiveRecord: function() {
var productGr = new GlideRecord('x_products');
var results = {
productcode: null,
currentQty: null
};
if (productGr.get(this.productId)) {
results = {
productcode: productGr.getValue('productcode'),
currentQty: parseInt(productGr.getValue('quantityonstock'), 10)
};
return results;
}
return results;
},
//Update Record
_updateRecord: function(vnewQty) {
var productGrUpd = new GlideRecord('x_products');
if (productGrUpd.get(this.productId)) {
gs.info('New value for productcode(' + productGrUpd.getValue('productcode') + ') = ' + vnewQty.toString());
productGrUpd.setValue('quantityonstock', vnewQty.toString());
var updResult = productGrUpd.update();
gs.info('updResult: '+ updResult);
gs.info('Updated the Record!');
}
},
//Zero Out Quantity
zeroOutQty: function() {
var response = this._retreiveRecord();
gs.info('response.currentQty =' + response.currentQty + ' for productcode ' + response.productcode);
if (response.productcode) {
const newQty = 0;
this._updateRecord(newQty);
return 'Record Found and Zeroed out for productcode ' + response.productcode;
}
return 'Record Not Found for sysid ' + this.productId;
},
type: 'processInventoryUtility'
};- After running the fix script, when I view the record in the x_product table, it is unchanged.
- x_product is in the ABC scope.
- Please note that I can update a different custom table in the scope.
- This x_product table is an extension of the sc_cat_item table, but the quantityonstock field is only in the x_product table as a custom string field.
I'm able to see that the record is found but the update statement returns null. See updResult in the system log below. There are not errors.
I can run the update portion of the script include with no problems from Background Scripts. But my understanding is that security posture is not as tight when running scripts in background scripts. I am running the script as WMS scope. (Below is a snippet of what I run in background script). My understanding is that this loose security posture holds true for imports also, as our transform map is able to update quantityonstock based on data provided in a file.
var productGrUpd = new GlideRecord('x_products');
if (productGrUpd.get('b829d27047d5ee50d56a0f6ba26d4346')) {
productGrUpd.setValue('quantityonstock', '0');
var updResult = productGrUpd.update();
gs.info('updResult: '+ updResult);
gs.info('Updated the Record!');
}
Note: I also can't update the field when viewing the list. No matter if I am in WMS or ABC scope.
I've also switched everything from WMS scope in terms of the script include and the fix script and created the same version of it under the ABC scope and still get the same results - No update happens.
- The field is not read-only
- I've checked business rules on both the x_products table and the table it extends sc_cat_item. The only business rule I see is global is to prevent an update when the record is checked out. We don't use this field and it is currently blank for all records in the x_products table.
- I've performed the cross-scope privileges.
- I've checked that the table allows for accessibility from All application scopes where caller access is None and can read/create/update/delete are all checked. Allow access to this table via web services and allow configuration are all checked.
- I did find something interesting in Form Builder that I hadn't seen before and wondering if this is the culprit. Attributes for the quantityonstock shows edge_encription_enabled=true. However if you view the Dictionary Entry for quantityonstock, it is empty under the attribute field. I only see it when viewing it in Form Builder as show below.
Could the edge_ecryption_enabled=true be my issue or some other type of security attribute or something special about extending from sc_cat_item? (NOTE: Don't think its related to edge_ecryption_enabled as we don't have it setup in our instance.)
Thanks in advance for your help on this topic!
