ESQL操作数据库总结

 

1.单引号里面直接写SQL语句，把查出来的结果放到环境树里面

 

SET beforeBusinessCursor.ext.NODE_PATH[] = PASSTHRU('select A.* from SD_DATA_NODE_PATH AS A left join SD_EVENT_INFO AS B on A.EVENT_ID=B.ID where B.TYPE_CODE='''||eventName||'');