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