We run a query via XML that performs a project search and translates the results using XSL.
We have the Query-Objects xml & xsd file on the server.
The result is an XML that shows projects & attributes.
The problem is in this output, the COLLECTION & INSTANCE is listed in a manner that Business Objects does not understand. When this is generated, Windchill adds the "wc:" in front of COLLECTION & INSTANCE. If we remove this, Business Objects can create the connection OK.
Does anyone know if we can modify this output to remove the "wc:"?
<?xml version="1.0" encoding="UTF-8"?>
<wc:COLLECTION xmlns:wc="http://www.ptc.com/infoengine/1.0"> -<com.amcorrigid.AM_PROJECT STATUS="0" TYPE="Object" NAME="output">
<wc:INSTANCE>
<AM_PROJ_SEGMENT>xxxxxxxxxxxx</AM_PROJ_SEGMENT>
<AM_PROJ_DESCRIPTION>xxxxxxxxxx</AM_PROJ_DESCRIPTION>
<AM_PROJ_NAME>xxxxxxxxxxxxxx</AM_PROJ_NAME>
<AM_CREATED>01/04/2010</AM_CREATED>
<AM_PROJ_TYPE>xxxxxxxxxxxxx</AM_PROJ_TYPE>
<AM_PROJ_NUMBER>xxxxxxxxxxx</AM_PROJ_NUMBER>
<AM_PROJ_STATE>COMPLETED</AM_PROJ_STATE>
<obid>OR:wt.projmgmt.admin.Project2:336391:590620213-1382658489836-1091773784-228-4-144-10@plm.amcorrigid.com</obid>
<class>WCTYPE|wt.projmgmt.admin.Project2|com.amcorrigid.AM_PROJECT</class>
</wc:INSTANCE>
