Skip to main content
View as Markdown

system.kanoa.inventory.updatePartCategoryField(partCategoryId, field, value, userId)

Updates a single named field on a part category record identified by partCategoryId. Use this function when only one column needs to change (for example, renaming a category or toggling its enabled flag) instead of passing a full partCategoryInfo dictionary to updatePartCategory. The field parameter must be one of the valid column names for the part category table, and value is supplied as its string representation.

Parameters​

partCategoryId Integer: Id of part category to update
field String: Valid options are categoryName, parentPartCategoryId, sortOrder, enabled
value String: Value to update to
userId Integer:Id of the user executing the function

Returns​

# of records modified Integer
message String None if success

Example​

# Bump the sort order of the "Electrical" part category
partCategoryId = 15
fieldName = 'sortOrder'
newValue = '4'
userId = system.kanoa.security.getIDPUserId({'userName': 'SYSTEM'})

recordsModified, message = system.kanoa.inventory.updatePartCategoryField(partCategoryId, fieldName, newValue, userId)
print recordsModified, message