注意:當(dāng)前為視頻教學(xué),文本教學(xué)可在視頻下方查看!
復(fù)制粘貼以下內(nèi)容到自定義字段覆蓋,各功能對(duì)應(yīng)的字段需要自行更換:
lcstate=isnull((select top 1 case when isnull(pz04314,0)=1 then '進(jìn)行中' 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),'未發(fā)起流程'),lcry=isnull((select top 1 st00602 from sdpz043 join sdst006 on st00601=pz04304 where pz04314>0 and pz04313=bs00301 order by pz04315 desc),'')










