Status Changes on Project | Community
Skip to main content
N
NRYNR
Level 10
May 13, 2016
Question

Status Changes on Project

  • May 13, 2016
  • 71 replies
  • 7736 views
I would like to create a report that provides the dates or elapsed days between status changes on a project. For example, days between Current to Pending Approval, Pending Approval to Pending Implementation, Pending Implementation to Closed. We would like to identify where significant delays occur within projects occurred. Suggestions?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

71 replies

T
TimGo1
Level 2
May 13, 2016

If you’re not talking about approval path timing, you should be able to get close by using the milestone view on a list of projects. This assumes you have 1) a milestone path set up that includes the different phase gates you want to track, and 2) you have aligned the project tasks to those milestone phases in the schedule.

Tim Golden

E
EricLu2
Level 10
May 13, 2016

Interestingly enough, I worked through this myself about two months ago:

Here is what I learned:

1) The date a change in status occurs is not stored in any database table or attribute;

2) The only place that change in status is documented is in the Audit attributes of the Note reporting object;

a. Note text is stuff people enter into updates;

b. Audit text is stuff the system documents;

3) To find it, you have to search the notes for a specific set of characters. I’ve tried to create a Note report that show audit (not note) text where:

a. Note>>audit text contains “approved”;

b. Note>>Thread date is greater than equal to $$TODAY-3w (this looks back three weeks);

4) That shows me all notes where the word Approved appears. You can search for other unique strings in the note texts this way. I have a version that shows all projects approved in the last three weeks and another that shows all projects that were moved into or out of another status;

If you want to report on where a project is in an approval workflow, it is a similar challenge. I have some text mode code to help with that.

Hope this helps.

    imgrund
    Adobe Employee
    imgrundAdobe Employee
    Adobe Employee
    May 16, 2016
    Going on what Lucas said, I would recommend a Note object type report and have the filter so the Audit Type is Status Change. The only thing I have not been able to figure out is how to isolate it for just the project. It currently pulls in all status changes on the project including changes to tasks and issues. There is a filter "Project - Audit Types" but when I used that I got a "SQL database error." So even though it is there, it doesn't look like you can use that.
    E
    EricLu2
    Level 10
    May 16, 2016

    There is an attribute called “Note ObjCode”

    DOCU – It is audit text on a document

    TASK – It is audit text on a task

    OPTASK – Something, not sure, but it is audit text

    Null – I think this is a note, not audit text.

    I can’t get to other values because of a defect that keeps changing my report filter criteria. Sorry. I just opened a ticket for that.

    Eric

    T
    TimGo1
    Level 2
    May 16, 2016

    OPTASK is an issue, if memory serves.

    G
    GregBe1
    Level 9
    May 16, 2016
    Yes, it is.
    G
    GregBe1
    Level 9
    May 16, 2016
    So, if you filter by Audit Type = Status Change, and Note ObjCode is blank, you should get all project status changes I think.
    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    May 18, 2016
    Hi Narayan. A couple of years ago a large Workfront client engaged us to build out a similar solution for tracking the response and resolution time on Issues. The resulting SLA (Service Level Agreement) Package has some very cool reports and dashboards on it such as this one , but The Math behind it is not for the faint of heart! That said, the end justified the means, and I'm certain it could be adapted to accomplish what you are after: tracking Status state-times at the Project level. Regards, Doug
    L
    LauraRa1
    Level 7
    August 30, 2016
    Hi there I've read through this thread and can't seem to pull all our projects where the status was changed in the last week. Sounds like adding a date to it can't be done but if I could at least pull a report that shows only project that have changed, that would work for us. I have a project report and have filtered it as suggested in this thread... Audit Type = Status Change, and Note ObjCode is blank This doesn't show any projects for me. Can you help?
    L
    LauraRa1
    Level 7
    August 30, 2016
    Correction... The report shows 4 projects but if I test it by changing the status of a project, it doesn't pull in that newly changed project so I believe it's not working.
    Show more replies
    Terms & ConditionsAccessibility statement

    Loading footer...