AnsweredAssumed Answered

XOG and Web Services - Simple Project Read Question

Question asked by rdasilva on Feb 3, 2011
Latest reply on Feb 8, 2011 by allen.bollinger
I am trying to use XOG/Web Services to retrieve all project's information for a particular manager within a particular year.

I am using CA Clarity 8.1.3

When using following call, XOG does not like criteria "LIKE", and it seems there is no filter for manager, either. Would someone know how to perform such query? Thanks! :

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:obj="http://www.niku.com/xog/Object">
[color][color]
<soapenv:Header>

<obj:Auth>

<!--Optional:-->

<obj:SessionID></obj:SessionID>

<!--Optional:-->

<obj:Username>username</obj:Username>

<!--Optional:-->

<obj:Password>password</obj:Password>

</obj:Auth>

</soapenv:Header>

<soapenv:Body>

<obj:ReadProject>


<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">

<Header version="8.1.3.4545" externalSource="NIKU">

<!-- you change the order by simply swap 1 and 2 number in the name attribute -->

<args name="order_by_1" value="name"/>

<args name="order_by_2" value="projectID"/>

<args name="include_tasks" value="false"/>

<args name="include_dependencies" value="false"/>

<args name="include_subprojects" value="false"/>

<args name="include_resources" value="true"/>

<args name="include_baselines" value="false"/>

<args name="include_allocations" value="false"/>

<args name="include_estimates" value="false"/>

<args name="include_actuals" value="true"/>

<args name="include_custom" value="true"/>

</Header>

<Query>

<!--

<FilterByCustomInfo name="project_billability" criteria="EQUALS">proj bill</FilterByCustomInfo>

<FilterByCustomInfo name="first_bill_date" criteria="BETWEEN">1999-01-07,2002-07-01</FilterByCustomInfo>

<FilterByCustomInfo name="project_risk" criteria="EQUALS">Medium</FilterByCustomInfo>

<FilterByCustomInfo name="profitable_project" criteria="EQUALS">true</FilterByCustomInfo>

<FilterByCustomInfo name="owner" criteria="EQUALS">last</FilterByCustomInfo>

-->

<Filter name="managerResourceID" criteria="EQUALS">RDAS</Filter>
<Filter name="projectID" criteria="LIKE">C11-*</Filter>



<!--

<Filter name="projectID" criteria="EQUALS">C11-143B</Filter>



<Filter name="active" criteria="EQUALS">true</Filter>

<Filter name="approved" criteria="EQUALS">true</Filter>

<Filter name="closed" criteria="EQUALS">false</Filter>

<Filter name="approvedForBilling" criteria="EQUALS">false</Filter>

<Filter name="start" criteria="BETWEEN">1999-01-07,2001-01-15</Filter>

<Filter name="finish" criteria="EQUALS">Customer</Filter>

<Filter name="lastUpdatedDate" criteria="EQUALS">2002-01-26T11:42:03</Filter>

<Filter name="resourceID" criteria="EQUALS">jsmith</Filter>

<Filter name="trackMode" criteria="EQUALS">2</Filter>

-->

</Query>

</NikuDataBus>



</obj:ReadProject>

</soapenv:Body>

</soapenv:Envelope>

Outcomes