You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Cloud Query Rules - Insert should also have a Where clause

posted on May 17, 2023

The insert statements do not have a where clause like select statements do but we still often need this because we might want to insert where does not already exist.

Right now we have to create another select rule just to get the where clause and run this rule for every row independently of calling our insert rule so we can wrap it in a conditional, not only does it require way more overhead and multiple rules to accomplish one task, but the business process modeler is not even logical enough to do this, only workflow.

 

0 0
replied on May 17, 2023

I too would love an UPSERT ability for cloud. It is very clunky to check if a value exists and then insert.

Also let me delete or do custom SQL for on premise datasources. I should not have to break into custom scripts do delete a SQL item.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.