This content has been marked as final.
Show 2 replies
-
1. Re: SQL for Event History details
Ivy Zhu-Oracle Jul 23, 2019 6:50 AM (in response to pnrajasekar)select fs.status as From_Status, ts.status as To_Status,h.userName,h.activityDate,h.Comments from dbo.SpecWorkflowAuditHistory h
inner join commonWorkflowStatus fs on fs.pkid=h.status and fs.langID=0
inner join commonWorkflowStatus ts on ts.pkid=h.NewStatus and ts.langID=0
where docID='%SPEC_PKID%'
-
2. Re: SQL for Event History details
pnrajasekar Jul 24, 2019 5:37 PM (in response to Ivy Zhu-Oracle)thanks