Clarity

  • Private Community
 View Only

  • 1.  Task Assignment ETC

    Posted Mar 05, 2013 10:15 PM
    Hi,

    Does anybody know the SQL query to fetch the Task ETC per resource? This is the ETC that you see inside a Task under the Assignments section.

    Thanks


  • 2.  RE: Task Assignment ETC
    Best Answer

    Posted Mar 06, 2013 12:53 AM
    Check the prassignment table, column name = prestsum
    prassignment.prresourceid = srm_resources.id
    prassignment.prtaskid = prtask.prid
    prtask.prprojectid = inv_investments.id


    NJ


  • 3.  RE: Task Assignment ETC

    Posted Mar 06, 2013 08:38 PM
    Thanks! That seems to work:smile


  • 4.  RE: Task Assignment ETC

    Posted Mar 07, 2013 12:53 AM
    Please mark the thread as "answered" in case the provided solution worked :happy:

    NJ