locked
PS 2013 - Query to display projects and their team members (or resources and their associated projects) RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Is anyone aware of a SQL query that would display resources and their associated projects?  Not just projects they have assignments in, but projects where they reside on the team.  As PWA has the ability to filter a specific users project list to display only associated projects in which they have assignments or reside on the team, conversely can we create a report that shows either projects and their team membership or resources and their associated projects?

    Chris Addis - MCTS


    Wednesday, May 18, 2016 1:03 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote 
    Use ProjectWebApp
SELECT PR.PROJ_NAME, PR.RES_NAME
FROM PUB.ProjectResource PR

    Wednesday, May 18, 2016 10:27 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote 
    Use ProjectWebApp
SELECT PR.PROJ_NAME, PR.RES_NAME
FROM PUB.ProjectResource PR

    Wednesday, May 18, 2016 10:27 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Simple and sufficient.  That query works and meets my needs.  Thank you Paul. 

    Chris Addis - MCTS

    Thursday, May 19, 2016 1:33 PM