When updating data attached to a collaboration server via sql, what is necessary to ensure changes are triggered?

Question

Is changing the version sufficient? (e.g. below). I understand this is risky.

UPDATE tbl_flows
SET
  FLOW_TYPE = 'PRODUCT_FLOW',
  VERSION = VERSION + 1
WHERE FLOW_TYPE = 'WASTE_FLOW'
  AND ID = 525;

Comments

Oh I see a similar question that is python based, so I think the answer is that yes the version is sufficient

https://ask.openlca.org/8835/comit-changes-existing-processes-flows-collaboration-server