Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

In PPM webservices, unable to search/open project on user defined fields

Highlighted
Reinier de Koni
Occasional Contributor

In PPM webservices, unable to search/open project on user defined fields

In our PPM instance we import projects from an external system through the PPM webservices. The primary identifier of these projects is a key from the external system. This key is stored in a PPM user defined field. This field can be found in the web GUI on the details tab of a project.
These imported projects are to be updated regularly, through the PPM webservices. To be able to update the PPM projects the external identifier needs to be used because the external system is not aware of PPM.

To exactly point out where the user defined field resides in the database the folowing SQL query may clearify things.
select parameter9 P_WBS,visible_parameter9 V_WBS from pm_projects pp, kcrt_req_header_details krhd where pp.pfm_request_id = krhd.request_id AND pp.pfm_request_id = 30186;

Is it possible to search or open projects through the web services based on these fields? Maybe it is better to use a different approach? Please advise.
//Add this to "OnDomLoad" event