Skip to main content
Planview Customer Success Center

How to link resource request data from ProjectedResourcesRequest table, to project data, in a custom data provider?

In a custom data provider we want to link information from a resource request (table ProjectedResourcesRequest) to information from the project table, e.g. to show the project name. Since there is no projectid in ProjectedResourcesRequest, how can we achieve that link?


You can join the table ProjectTeam on the column RequestId, and then join the Project table on ProjectId

Example:

SELECT p.name Project, p.projectid, prr.*
FROM DS_ProjectedResourcesRequest prr
LEFT OUTER JOIN ProjectTeam (nolock) pt ON pt.RequestId=prr.RequestId AND pt.deleted=0
LEFT OUTER JOIN Project (nolock) p ON p.projectid=pt.projectid