Does anyone know a way to report on Sign Off Duration for Activities?

There is a User Signoff Duration Report, but that only works for changes.  If there is no OOTB solution, does anyone have a SQL for this?

Add Comment
4 Answer(s)

I’d imagine it’s the sign SIGNOFF table and the same SQL as you would pull with other changes, though I don’t have PPM to confirm this.  Try it by: <select * from SIGNOFF s, ACTIVITY a where a.id = s.change_id> and go from there.

Agile Angel Answered on April 19, 2018.
Add Comment

Thanks for the reply Matt!  Yes I got that far, and a little further, but struggled with having my SQL match the signoff duration, on the workflow tab of task, because the app is calculating business days dynamically.  I’m unclear on how to get the business days difference into my query.  I was hoping someone already invented this wheel.

Agile User Answered on April 19, 2018.
Add Comment

I’ve used these two lines to calculate date difference:
ROUND((LAST_UPD – CREATED),2) as DateDiff
ROUND((select sysdate – interval ‘8’ hour – s.created from DUAL), 0) as elapsed

I’ve ran into the same thing and I know what you’re talking about, so I used the second line to get the most accurate (I have to subtract 7 or 8 hours for Pacific Standard Time). 

Make sure you check your server preferences to see if it’s counting weekends or not.

Agile Angel Answered on April 19, 2018.
Add Comment

Thanks Matt, that seemed to work, appreciate the help.

Agile User Answered on April 20, 2018.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.