How do I Search Projects using PSI

[cwmenke]

My goal is to return projects matching a value in the Project or in
some of the project's Enterprise Custom Fields (only the Project and
ProjectCustomFields tables).

So far, the only way I can think of accomplishing this is:

Read the list of projects using ReadProjectList();
For every row in the list of projects
{
Read the entire project
Check the fields in that project
}

Could someone point me in the right direction?

 

[Dale Howard [MVP]]

cwmenke --

I think you should repost this message in the
microsoft.public.project.developer newsgroup, as you are more likely to get
an answer in that group. Hope this helps.

 

[cwmenke]

cwmenke --

I think you should repost this message in the
microsoft.public.project.developer newsgroup, as you are more likely to get
an answer in that group.  Hope this helps.











- Show quoted text -

Thanks for the reply. I did not realize there was a developer group
and I will repost it there.

 

[Paul Conroy]

The SDK includes some demo code which may help you with this.

http://www.microsoft.com/downloads/...F9-7028-4B30-99A2-18CB1EED1ABE&displaylang=en

 

[Kit]

The SDK includes some demo code which may help you with this.

http://www.microsoft.com/downloads/details.aspx?FamilyId=2672F6F9-702...








- Show quoted text -

Thanks but I have already been using the SDK. Unfortunately, there
does not seem like a good way to search projects (and potentially a
projects custom fields) out of the box.

I also posted this question here:
http://groups.google.com/group/micr...per/browse_frm/thread/ad18929c53b7b2e5?hl=en#

 

[tonyzink]

My goal is to return projects matching a value in the Project or in
some of the project's Enterprise Custom Fields (only the Project and
ProjectCustomFields tables).

So far, the only way I can think of accomplishing this is:

Read the list of projects using ReadProjectList();
For every row in the list of projects
{
Read the entire project
Check the fields in that project

}

Could someone point me in the right direction?

Hi Kit --

Since you mentioned the PSI, I assume that we're talking about Project
Server 2007, rather than 2003?

If so, do you happen to have Project Server installed with MOSS
(Microsoft Office SharePoint Server) 2007? There is a terrific tool
called the Business Data Catalog (BDC) that's included with the
Enterprise version of MOSS2007 that can be used to build a feature-
rich search engine for your project server. Imagine being able to
search through projects, tasks, resources, issues, risks, and
deliverables... including their respective metadata fields!

If you don't have the luxury of having MOSS2007 to work with, you can
certainly access project-related data through another SharePoint-based
technology... Data View Web Parts (DVWPs). However, you'll need to
have access to another tool -- SharePoint Designer -- to build that
type of tool. It's CONSIDERABLY less expensive than deploying
MOSS2007, however! I've started writing about this method on my blog
(http://www.pptspaces.com/msprojectreporterblog), in the post titled
"Solution-Building for Non-Geeks".

If you're interested in learning more about either of these NO-CODE
techniques of interacting with Project Server data, please post your
reply here.

Good Luck!

Tony Zink
Senior Consultant
MSProjectExperts
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We write the books on Project Server"