Where is the Project Priority Stored?

[Skip B]

I'm trying to write a couple of custom queries against the Project DB and
cannot seem to find where the project level priority (accessed when you
select the project properties - not at the task level) is stored. Anyone
have a clue?

Thanks!...Skip

 

[Marc Soester]

Hi Skip,

when you say Project level Priortiy, do you refer to an outline code or
custom Field?
If so you may need to check which custom field and you can then get your
querie looking for this custom field

I hope this helps

 

[Skip B]

Neither. If you look at the "project" information dialog box, there is a
priority field that is at the project level. I'm trying to locate that field
in the database. It is set for the project overall and changing the priority
of particular tasks does not affect that setting. Priority is one of the
native fields to project. Does this make sense?

 

[Gary L. Chefetz [MVP]]

Skp:

I think you need to use the API to access this. Not all of the project
properties are exposed in the project tables. Some are only accessible
through project object properties.

 

[Skip B]

I'm looking for the data in the SQL server database directly. No need for an
API, I do not believe. I'm not sure what you mean by your reply. Are you
suggesting it is a derived field? By the nature of the data (i.e. priority
being for all tenets and purposes a numeric indentifier rather than a true
"value") I would assume it is a stored value. The behavior that makes me
think this is that I can set the project priority and then assign differing
priorities to tasks and the project priorty remains unchanged.

Any thoughts from anyone?