原sql
select
poa.poano,
wftask.starttime,
wftask.endtime,
wftask.taskname,
extract(day from wftask.endtime-wftask.starttime) wftaskDay,
extract(hour from wftask.endtime-wftask.starttime) wftaskHour,
extract(minute from wftask.endtime-wftask.starttime) wftaskMin,
usr.realname wftaskExcutor,
usr2.realname wftaskPrevExcutor
from co_workflow_task wftask
inner join co_user usr
on wftask.Executor = usr.username
inner join co_user usr2
on wftask.Prevexecutor = usr2.username
inner join tb_sm_poa_info poa
on poa.id = wftask.Extendfield1
uj5u.com熱心網友回復：
大佬們。重復的那些taskname對應的時間，是因為執行人不同，只取1行的時間進行計算。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/266071.html
標籤：開發