none
Projects with task that have a publish field set to NO in PWA DB RRS feed

  • Question

  • I am looking a query to get the data of projects with task that have a publish field set to NO. Also, I don't have any idea where is the publish field. 
    Wednesday, January 18, 2017 8:04 PM

Answers

  • Hi,

    it seems to be a task field, but information is stored in Assignment table.

    SELECT        P.ProjectName
    			, T.TaskIndex
    			, R.ResourceName
    			, T.TaskName
    FROM            dbo.MSP_EpmAssignment_UserView AS A 
    INNER JOIN dbo.MSP_EpmTask_UserView AS T 
    	ON A.TaskUID = T.TaskUID 
    INNER JOIN dbo.MSP_EpmResource_UserView AS R 
    	ON A.ResourceUID = R.ResourceUID 
    INNER JOIN dbo.MSP_EpmProject_UserView AS P 
    	ON T.ProjectUID = P.ProjectUID
    WHERE (A.AssignmentIsPublished = 0)
    Hope that helps?
    Barbara


    To increase the value of this forum, please mark the replies that helped to solve your issue as answer. If you find answers to questions from other forum participants to be helpful, please mark them as helpful. Your participation will help others to find an appropriate solution faster. Thanks for your support!

    • Marked as answer by marod1971 Thursday, January 19, 2017 12:44 PM
    Thursday, January 19, 2017 7:09 AM
    Moderator

All replies

  • Hi,

    it seems to be a task field, but information is stored in Assignment table.

    SELECT        P.ProjectName
    			, T.TaskIndex
    			, R.ResourceName
    			, T.TaskName
    FROM            dbo.MSP_EpmAssignment_UserView AS A 
    INNER JOIN dbo.MSP_EpmTask_UserView AS T 
    	ON A.TaskUID = T.TaskUID 
    INNER JOIN dbo.MSP_EpmResource_UserView AS R 
    	ON A.ResourceUID = R.ResourceUID 
    INNER JOIN dbo.MSP_EpmProject_UserView AS P 
    	ON T.ProjectUID = P.ProjectUID
    WHERE (A.AssignmentIsPublished = 0)
    Hope that helps?
    Barbara


    To increase the value of this forum, please mark the replies that helped to solve your issue as answer. If you find answers to questions from other forum participants to be helpful, please mark them as helpful. Your participation will help others to find an appropriate solution faster. Thanks for your support!

    • Marked as answer by marod1971 Thursday, January 19, 2017 12:44 PM
    Thursday, January 19, 2017 7:09 AM
    Moderator
  • Thanks so much Barbara.
    Thursday, January 19, 2017 12:46 PM