PHP IDE :: NuSphere Forums :: View topic - Using nuSOAP to send a query to Stellent/Oracle UCM

Posted: Thu Jul 02, 2009 4:05 am

Hi there,

i am trying to use the webservice of an Oracle UCM server to search for a specific document.

All i am trying to do is a search in the following pseudosqlcode:

Code:

WHERE 'dDocTitle' = "testBild4Nagios.png"

I can successfully call the AdvancedSearch webservice and perform a search with the following code:

Code:

$result = $soap->AdvancedSearch(array(
'queryText'=>""
));

That way i get all documents as a search result.

Now how do I add the before mentioned WHERE clause?

I know that all parameters must be XML encoded, so I tried out:

Code:

$queryText = 'dDocType <Substring> "testBild4Nagios"';

But I still get the error message:

Code:

[statusMessage] => The query could not be executed. Invalid character in the query position 9: "dDocType <Substring> "testBild4Nagios""

Position 9 is the first blank in the queryText.

I also tried out urlencode to remove the blank character but still no success.

Could you help me with this?
Does the nusoap class already transform the parameters to XML or in any other way?

Thanks in advance!

Posted: Thu Jul 02, 2009 4:51 am

As usual I found the solution right after I posted this ...

I didn't tried

Code:

$queryText = "dDocTitle <substring> `testBild4Nagios.png`";

without urlencode ...

Now it works as it should.

Maybe someone else can use my php script:
links to the other sites are prohibited because of high spam activity

links to the other sites are prohibited because of high spam activity