SQL示例

注意

若通过SQL节点对表单数据进行修改后，还有其他审批节点，需要开启数据快照同步

SQL节点支持groovy和freemark两种格式，推荐使用groovy

groovy脚本(推荐)

def businessKey = variables["zc_business_key"];
def sql = "update demo set state = 1 where business_key = '$businessKey'";
//process打印sql
println sql;
return sql;

freemark脚本

update demo set state = 1 where business_key = '${formData["zerocloud_data"]["test"][0]["business_key"]}';