哪位高手可以帮忙解释一下SQL 中[%=]的意思

新手上路,请多包涵

SELECT * FROM WF_INSTANCE A, WFV_TASK B, G_PRJ_XMXX C
WHERE A.INSTID = B.INSTID [%=if(isSuperAdmin(curUser()),""," AND ((B.FINISHUSER IS NOT NULL AND B.FINISHUSER='"+curUser()+"' OR B.FINISHUSER IS NULL AND B.EXECUSER IS NOT NULL AND B.EXECUSER='"+curUser()+"') OR (B.FINISHUSER IS NULL AND B.EXECUSER IS NULL AND ((B.EXECROLE IS NOT NULL AND "+concatCols("wfdata","B.ROLESUBSYS,'.',B.EXECROLE")+" IN ("+userRoles(curUser(),null,",",true)+")) OR B.EXECROLE IS NULL)))" + if(hasRole('appzjgg', 'SJ_GBKZ') || hasRole('appzjgg', 'SJ_JB'), " AND C.CORG_ IN (select ORGANISEID from ORGANISE where PARENTID = '" + curOrg() + "')", ""))%]
ORDER BY B.ARRIVETIME DESC

阅读 2k
1 个回答

这个不是标准的sql语句,应该是某种模板语言,用来根据变量拼接出sql语句。

撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进