PS2007 PSI: Filtering resources on custom field value

[Cramezul]

Hi,

I have a "JobType" enterprise custom field defined on resources. My C# app
must show a list of the resources that have the "Inspector" job type.

The only solution I see for the moment is something like this

ReadResources()
foreach resourceUid
ReadResource(resourceUid)
Look for JobType custom field
if JobType custom field exist and value == [Inspector value]
AddResourceToResultList...

Something tells me that ther should be a better way of doing this. Any idea?

Thanks

 

[Sharry Heberer [MSFT]]

Have you read this article:
http://msdn2.microsoft.com/en-us/library/ms453399.aspx

You should be able to create a filter on ReadResources that limits the rows
returned based on the criteria you specify.

Hope this helps,
Sharry

 

[Cramezul]

Have you read this article:
http://msdn2.microsoft.com/en-us/library/ms453399.aspx

Yes I already seen it. What I understand is that I can create a Filter to
restrict the result to one table and specify criteria to filter on this table
field values. In my case, I want to show the result of the Resources table
filtered by a values in another table: ResourceCustomFields.

Does filter allow this? If yes, how do we construct such a criteria?

Thanks,

 

[Sharry Heberer [MSFT]]

So I've done a little digging on this, and it should be possible, except
that there is a problem in ReadResources when you are filtering on CF
values. I will submit this issue for consideration in a future release, but
if you need a more immediate solution, then you should work with the
Microsoft Support organization.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm