What database table is Resource Group information in?

J

Joe

Does anyone know which table and field the Resource Group is stored in? I
want to limit my result set to s specific resource group.
 
R

Rod Gill

In one of Project's program folders is a file called pjdb.htm (prjdb.htm for
pre 2003). It has names of all tables and information on all fields.
 
J

Joe

Rod,

I am aware of this file, but I could not find the "Resource Group" field in
any of the tables. I thought it would be in the Resoruce table or some
supporting table, but did not find it. Do you know which table has this info?
 
R

Rod Gill

Hi,

For some reason the Resource Group is saved as custom text in the
MSP_Text_Fields table. Resource Group text has a Text_Field_Id of 205520899
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Base calendar interaction with a resource calendar 0
Resource graph/total for a filtered set of tasks 0
MSP 2010 - Global Replacement of Resources in a Project 2
Project 2007 Work Field Formula to Exclude Work Done by Resources Not in a Resource Group 0
Level resource allocation error 1
Individual vacation calendars in a team resource 0

Top