Faster Way to update custom fields

[SBarnes]

In 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?

Code: Select all

var custValue = JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValueCollection.ReadCustomFieldValue(manager, "Inventory Maintenance", item.TSAInventoryID, "ExternalID");


[Mike.Sheen]

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?

No.

But you could add an extension method yourself to do something similar to what the ReadCustomFieldValue method does, but for writing.

[SBarnes]

Would there need to be anything to be aware of like last updated/modified dates on the main entities or do they not get set by custom fields?