orcle语句中添加连接路径作为一个参数
--知识待办,其中$currentuser$是当前用户,想要写 select wb.id wbid, max(wb.workflowname) title, '/ServiceAction/com.velcro.workflow.workflow.servlet.WfViewAction?pipeid=402881e46af572a9016af578c5320092 &workflowid='|| wb.id as url, max(h.objname) username, '/ServiceAction/com.velcro.nc.vbase.action.urlLinkRequestAction?action=personView&id='|| max(wb.creater) as userurl, max(wb.createdate) createtime from workflowbase wb left join workflowoperators wo on wb.id = wo.workflowid inner join humres h on h.id = wb.creater inner join humres h1 on h1.id = wo.userid left join nodeinfo n on n.id = wb.curnodeids where wb.isdelete=0 and wo.userid='402881e70be6d209010be75668750014' and wb.pipeid='402881e46af572a9016af578c5320092' and wb.isfinished=0 and wo.istodo=1 and wo.operated<2 and wo.operatetype>1 group by wb.id order by createtime desc