You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
varorderList=property("zsdgData");log("Error","过滤前的数据总数:"+orderList.length)varorderIds=orderList.map(x=>"'"+x['Delivery_Number']+'-'+x['Delivery_Item']+"'");varqueryParams={ids: orderIds.join(',')};log("Error","queryParams:"+JSON.stringify(queryParams))//查询数据库中已存在的项 varresult=executeQuery("SCMQueryExistsedOrderIds",queryParams)//output:{"Count":36,"Capacity":64}log("Error","qurey result:"+JSON.stringify(result))varfilterdData=orderList;//排除数据库中已存在的条目if(result!=null){log("Error","qurey result is not null"+JSON.stringify(result))// varidResult=result.map(x=>x.DisplayText)filterdData=orderList.filter(x=>idResult.indexOf(x['Delivery_Number']+'-'+x['Delivery_Item'])==-1)}log("Error","过滤后的数据总数:"+filterdData.length)setProperty("zsdgData",filterdData)setOutcome('Done');
log out put:
input counts :12
queryParams:{"ids":"'145163194-10','145163285-10','145163288-10','145163304-10','145163307-10','145163315-10','145163318-10','145163323-10','145163325-10','145163327-10','145163329-10','145163331-10'"}
result :{"Count":36,"Capacity":64}
result is not null :{"Count":36,"Capacity":64}
An unhandled error occurred while executing an activity. Workflow ID: '143'. Activity: '4495mt0yfpjm2vn0pc32yd5ex1', 'ScriptTask'. Putting the workflow in the faulted state. Jint.Runtime.JavaScriptException: Property 'map' of object is not a function
at :15:2 at :15:2
The text was updated successfully, but these errors were encountered:
This is my query:
and this is my code :
log out put:
The text was updated successfully, but these errors were encountered: