Test on Type in Resource Center

[Robert]

Hi,

In Project Server 2007 SP2
In the Resource Center of PWA, I'm trying to filter on the resource's Type :
Work, Material, Cost
But the system reject any test on these words. It seems it's waiting for
numeric values.
Have you any idea to test on this Type field?
Thanks

 

[Dale Howard [MVP]]

Robert --

Even though the Type field displays text data, the underlying data is
actually numeric. So, you have to test for the following numbers in your
Filter:

Work resource = 0
Material resource = 1
Cost resource =2

Hope this helps.

 

[Robert]

Thanks a lot Dale,

I already tried to filter on these values, without any success.
I ran a SQL query on the Published DB:
USE ProjectServer_Published
SELECT RES_ID, RES_NAME, RES_TYPE, RES_MATERIAL_LABEL, RES_IS_TEAM
FROM MSP_RESOURCES
ORDER BY RES_ID
This SQL query returned the following values:
Work = 2
Material = 21
Generic = 20
Inactive = 102
Budget = 54
Cost = 25
But any filter test on these values returns nothing.
It seems that all these values are negative numbers...

"Dale Howard [MVP]" <dale[dot]howard[at]msprojectexperts[dot]com> a écrit
dans le message de (e-mail address removed)...

 

[Robert]

Dale,
The filters created in the Resource Center with a criterion on the Type
field don't work at all. But the same filters created in the Edit View page
work fine. And your numeric values for Work, Material and Cost are the good
ones.
Thanks again


"Dale Howard [MVP]" <dale[dot]howard[at]msprojectexperts[dot]com> a écrit
dans le message de (e-mail address removed)...

 

[Dale Howard [MVP]]

Robert --

Oddly enough, if you filter directly on the Resource Center page, you have
to filter for the text values. But if you build a filter as part of a
Resource Center view, you have to filter for the numeric values. Go figure!
Hope this helps.

Dale,
The filters created in the Resource Center with a criterion on the Type
field don't work at all. But the same filters created in the Edit View
page work fine. And your numeric values for Work, Material and Cost are
the good ones.
Thanks again


"Dale Howard [MVP]" <dale[dot]howard[at]msprojectexperts[dot]com> a écrit
dans le message de (e-mail address removed)...

Robert --

Even though the Type field displays text data, the underlying data is
actually numeric. So, you have to test for the following numbers in your
Filter:

Work resource = 0
Material resource = 1
Cost resource =2

Hope this helps.