/**
* @author QiaoChu
* @codeName 根据发货单号批量更新设备编号/设备状态
* @description 根据发货单号批量作废设备/设备状态
* @notice 查找关联类型的字段得传[主键:_id]
* @params field_tkHAh__c 设备关联发货单编码
*/
String name = context.data['name'];
String suffixName = "-" + name.split('-')[1];
QueryResult queryRes = Fx.object.find("DeviceObj",
FQLAttribute.builder()
.columns(["_id", "device_code"])
.queryTemplate(QueryTemplate.AND(["field_tkHAh__c": QueryOperator.EQ(context.data['_id'])]))
.build(),
SelectAttribute.builder().build()).result() as QueryResult
List dataList = queryRes.dataList;
log.info(dataList)
dataList.each { item ->
log.info(item)
String objectId = item["_id"] as String
String deviceCode = item["device_code"] as String
log.info(objectId)
log.info(deviceCode + suffixName)
def (Boolean error, Map data, String errorMessage) = Fx.object.update("DeviceObj", objectId, ["life_status": "invalid", "device_code": deviceCode + suffixName], UpdateAttribute.builder().triggerWorkflow(false).build())
if (!error) {
log.info(data)
} else {
log.info(errorMessage)
}
}
参考:
1、Fx.object.find
Fx.object | 纷享销客 | 帮助中心
2、Fx.object.update
Fx.object | 纷享销客 | 帮助中心