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

 

posted @ 2022-06-23 14:43  java璀璨小菜鸟  阅读(52)  评论(0)    收藏  举报