Filter Resources by Custom Field value using standard PSI calls

R

Roy G

All,
We need to retrieve resources from the enterprise resources pool using
standard PSI calls but we want to filter them by an Enterprise Custom Field
value (for example "Location" since there may be over 50K resources).
Filtering by resource GUID, name etc. is simple and the SDK provides a
useful example but there is no indication of how to use another table such as
teh custom fields table (we need a JOIN between the two tables).

Kind regards,

Roy
 
R

Roy G

Hi Stephen,

Thanks for your reply but perhaps I wasn't clear enough on my previous post.
I don't want to retrieve all resources along with their "Location" Custom
field using a PSI ReadResources (I know it can be done) because the DataSet
will contain over 50K resources. I would like to call ReadResources filtered
by Location to retrive let's say 500 Rresources from a certain location.
This is a simple query that can be retrieved from the RDB but I want to use
the standard PSI calls.

Thanks,
Roy
 
S

Stephen Sanderlin

Ah, okay. I misinterpreted your initial post -- my apologies.

Unless I am missing something in the SDK (and my memory), there's no way
to filter the results of a call to ReadResources() with a filter (even
using Fields.Add). My suggestion would be to create a PSI extension that
would accept a filter on custom fields and return a ResourceDataSet
populated with the information you need.

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com
 
R

Roy G

Thanks Stephen,
Your suggestion is exactly what I intend to do. I just wanted to consult
with others if it's possible to complete this task using he standard PSI
calls.
Regards,
Roy
 

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

Determining "nullness" of custom fields using VBA (not PSI) 6
Correct algorithm to create Project using PSI? 3
How to save project custom field value thru PSI 1
need to set value for a custom field 0
Search for a project by enterprise custom field with PSI 5
Update Resource Standard Rate Using PSI 0
Time Phased Actual Work updates for Project Resources? 2
How to update Task Enterprise Custom Field with a Lookup Table? 0

Top