none
extract submitted hours for task RRS feed

  • Question

  • i have task has submitted and saved hours, and i need to extract only submitted hours

    i will give you an example:

    if i submit 10 hours on task(task_ID=xxxx) and put another 10 hours and press save, i need to display table as below:

    Task            Hours

    xxxx              10

    so, i need to find something that differentiate between submitted hours and saved hours per task, does the project server contain any status to differentiate between the submitted and saved hours.

    Wednesday, May 8, 2013 7:59 AM

All replies

  • Once the hours are approved,  you will see those hours in the "Actual Hours".  You may have to insert this column to see the values.

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Sunday, May 12, 2013 7:25 PM
    Moderator