注意:当前为视频教学,文本教学可在视频下方查看!
复制粘贴以下内容到自定义字段覆盖,各功能对应的字段需要自行更换:
lcstate=isnull((select top 1 case when isnull(pz04314,0)=1 then '进行中' when isnull(pz04314,0)=2 then '已审批' when isnull(pz04314,0)=3 then '已拒绝' else '' end from sdpz043 where pz04314>0 and pz04313=bs00301 order by pz04315 desc),'未发起流程'),lcry=isnull((select top 1 st00602 from sdpz043 join sdst006 on st00601=pz04304 where pz04314>0 and pz04313=bs00301 order by pz04315 desc),'')