There are certain gel scripts that we use on our on-premise Clarity application which use <sql:update> tags and directly update the database.
These are at various places on the scripts, upon different if-else conditions (as per logic), they are used.
We are looking to replace these "Update" statements with XOG or any other approach which will make these gel scripts acceptable on on-demand.
Are there any best practices for these replacements?
Is XOG the only way to replace these or there are any other ways?