Groovy代码如下:
//工单流程状态 进行中、其他
List statusList = ["in_progress", "other"];
//业务类型
def recordType = "record_m4ElO__c";
//def caseId = "6673716fa75eb1000122d7b5";
//name = "20240620019289";
//def caseId = "666b88a4a75eb10001fef4bf";
//name = "20240614019053";
def searchCondition = QueryTemplate.AND(
//["_id": QueryOperator.EQ(caseId)],
["field_workflowStatus__c": QueryOperator.IN(statusList)],
["record_type": QueryOperator.EQ(recordType)]
)
Fx.log.info("查询条件为 :" + searchCondition)
//查询条件 要以id 进行排序,find默认的排序是最后修改时间,如果排序字段存在重复,数据库是不能保证每次查询出来顺序是一致的
//分页的时候可能会出现重复数据,导致执行遗漏。
Map orderBy = ["_id": -1]
boolean hasData = true
Integer limit = 100
//循环聚合所有数据
Map updateData = [:]
Range range = Ranges.of(0, 200)
range.each { i ->
if (hasData == false) {
return
}
Integer skip = i * limit
def (Boolean error, QueryResult result, String errorMessage) = Fx.object.find("CasesObj",
FQLAttribute.builder()
.orderBy(orderBy)
.limit(limit)
.skip(skip)
.columns(["_id", "name", "field_workflowStatus__c", "cases_status"])
.queryTemplate(searchCondition)
.build(),
SelectAttribute.builder().build())
if (error) {
hasData = false
Fx.log.info("查询失败" + "当前跳过的数量为 " + skip + "错误原因为" + errorMessage)
return
}
//获取所有更新的数据,如果是预设对象,就在循环里面直接更新。
List dataList = result.dataList
if (dataList.size() < limit) {
hasData = false
}
//如果不需要合并数据,在这里就可以100条
dataList.each { item ->
Map objectData = item as Map
log.info(objectData)
updateData.put(objectData._id, objectData._id)
}
}
//极端情况,所有查询都失败了
if (!updateData) {
Fx.log.info("循环查询出来数据为空")
return
}
//如果是自定义对象,直接调用更新即可,更新单次500条限制,所以我们拆分数据
List idList = updateData.keys() as List
//log.info(updateData)
//log.info(idList)
List partitionList = Fx.utils.listPartition(idList, 500)
partitionList.each { item ->
Map currentUpdateMap = [:]
//根据id分批组装数据
List ids = item as List
ids.each { id ->
String stringId = id as String
//工单流程状态:取消-cancel、状态:关闭-4
def result2 = Fx.object.update("CasesObj", QueryTemplate.AND(["_id": QueryOperator.EQ(stringId)]), ["field_workflowStatus__c": "cancel", "cases_status": "4"], UpdateAttribute.builder().build()).result() as String
if (result2) {
QueryResult data2 = Fx.bpm.findInstances("CasesObj", "in_progress", stringId, 100, 1)[1]
log.info("query instances data:" + data2)
if (data2 != null && data2.size > 0) {
List<Map> dataList2 = data2.dataList;
dataList2.each { it2 ->
String instanceId = it2.instanceId;
String workflowName = it2.workflowName;
log.info("instanceId:" + instanceId + ",workflowName:" + workflowName)
//参数是:流程实例id , 终止原因(可以根据自己的业务,修改下原因)
APIResult ret2 = Fx.bpm.cancel(instanceId, "统一终止");
if (ret2[0] == false) {
//执行到这里 说明终止已经成功了
log.info("bpm instance cancel success,instanceId:" + instanceId + ",workflowName:" + workflowName)
} else {
log.info("ret:" + ret2)
}
}
} else {
log.info("no data found:" + data2)
}
}
log.info(result2)
}
}
Fx.log.info("实际的数据为" + idList.size())
参考:
1、Fx.object.find
Fx.object | 纷享销客 | 帮助中心
2、Fx.object.update
Fx.object | 纷享销客 | 帮助中心
3、Fx.bpm.cancel
Fx.bpm | 纷享销客 | 帮助中心