SQL for waiting Approval for changes that require 80% Approval

Carol_MorrellCarol_Morrell Customer IT Monkey ✭


Comments

  • Carol_MorrellCarol_Morrell Customer IT Monkey ✭

    Hi we are struggling to work out how to include Change Requests that haven't been fully approved (it by 80%) in our SQL query for Change Requests awaiting approval.  We are doing a search on the parent work item in service management for activities starting 'RA', but this record seems to go when it is approved by 1 person.  Has anyone any ideas how we can do this?

  • Carol_MorrellCarol_Morrell Customer IT Monkey ✭

    We have used the SQL previously posted by Shane and it works perfectly, except for our Emergency changes that require approval by 80%.  As soon as 1 person approves them, they disappear from the report, but aren't approved until 80% have approved them and can't work out how to keep them on the report

  • Carol_MorrellCarol_Morrell Customer IT Monkey ✭

    Please see the attached SQL.


Sign In or Register to comment.