SQL for Event History details

pnrajasekar Jul 20, 2019 11:48 AM

Hi there,

I'm trying to construct SQL query to extract Event History details of Material Specification - please help suppose if you have details handy.

Material Specification -> Approval/Audit Trail -> Approval/Audit Trail -> Event History (From Status, To Status, User, Time, Comments)

where condition is spec-number

PLM Version: v6.2.2.

Regards,

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%'
Like Show 0 Likes(0)

Actions
2. Re: SQL for Event History details

pnrajasekar Jul 24, 2019 5:37 PM (in response to Ivy Zhu-Oracle)

thanks
Like Show 0 Likes(0)

Actions

Join the world’s largest interactive community dedicated to Oracle technologies.