SELECT wfnode.title, wfnode.description, wfa.roleid, r.description FROM wfnode JOIN wfassignment wfa ON wfa.nodeid=wfnode.nodeid AND wfa.processrev=wfnode.processrev AND wfa.assigncode IS NULL JOIN maxrole r ON r.maxrole=wfa.roleid WHERE wfnode.processname='[PNAME]' AND wfnode.processrev=[PREV] AND wfnode.nodetype='WFTASK' ORDER BY wfnode.title;
Labels: intermediate, sql, workflow