Home

SQL Report for Open changes and Awaiting Approvals

Does anyone have SQL code for extracting open changes and all pending approvals?

Agile User Asked on June 17, 2015 in Agile PLM (v9),   Product Collaboration.
Add Comment
Cancel
4 Answer(s)

See my answer to this question:

http://www.myagileplm.com/question/eco-and-approver-report/

Cancel
Agile Angel Answered on June 18, 2015.
Add Comment
Cancel

Hi Adrian,

Thank you for your response. I am running this is Toad and getting an error. See the attached screen shot.

Best regards,

Nelly

Cancel
Agile User Answered on June 18, 2015.
Add Comment
Cancel

Hi Nelly,

The perils of cut & paste 😉  SQLdeveloper is a bit more helpful in pinpointing the actual problem

RE: SQL Report for Open changes and Awaiting Approvals

Looks like the minus sign on line 6 is not seen as a valid character delete and retype. You will then find the single quotes used on line 14 have been transformed into accents so need editing.

Cancel
Agile Angel Answered on June 18, 2015.
Add Comment
Cancel

Adrian,

thank you!

Cancel
Agile User Answered on June 18, 2015.
Add Comment
Cancel

Your Answer

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