I don't want to add new rows to the TS_MULTIUSERUSAGES table in my Appscript directly. Is there another way to trigger SBM to add or delete rows in that table?
Accepted AnswerEmployeeGarry WomackOffline0When updating Multi-Valued fields via scripting objects, update the delimited version of the field on the primary or aux record only - do not manipulate the TS_USAGES or TS_MULTIUSERUSAGES tables directly. The product will keep the usages tables updated accordingly. I personally have not seen sync issues with this approach (there is very likely to be issues if modifying the usages tables directly).
As a general rule, I do not recommend directly updating the secondary owner field via scripting unless you must. The content of the secondary owner field should be driven by a separate user/multiuser/multigroup field ideally so that updates made by the script are not lost when the product has reason to recalculate the field (such as on other transitions). I have seen scenarios where you may need to update both the driving user field and the secondary owner field when making updates via scripting objects. But if using a transition mechanism, you should be able to just set the driving user field.