Faster Way to update custom fields
Posted: Fri Mar 14, 2025 12:51 pmIn an integration I have been working on it is necessary to update a custom field on an inventory item and in the intial load to the other platform this involves over 9,000 items
Whilst I can use something like the below, to see if the value is set already, is there away to avoid having having to load the business object to save the value to a custom field except for resorting to a raw SQL statement?
Whilst I can use something like the below, to see if the value is set already, is there away to avoid having having to load the business object to save the value to a custom field except for resorting to a raw SQL statement?
- Code: Select all
var custValue = JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValueCollection.ReadCustomFieldValue(manager, "Inventory Maintenance", item.TSAInventoryID, "ExternalID");