Unable to XOG out projects when using FilterByCustomInfo tag

book

Article ID: 144109

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

We are using the below projects read XML to xog out projects from Clarity via SOAP calls.

Trying to use the "FilterByCustomInfo" tag to filter only for projects where the flag for the field = whg_playbook_req_y_n is set to No.

 

*************READ XML**************************************

 

<?xml version="1.0" encoding="UTF-8"?>

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

  <Header version="6.0.11" action="read" objectType="project" 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="false"/>

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

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

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

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

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

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

  </Header>

  <Query>

 

    <FilterByCustomInfo name="whg_playbook_req_y_n" criteria="EQUALS">No</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="projectID" criteria="EQUALS">PRJ0091490</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> 

*************READ XML**************************************

 

The tag is here -

FilterByCustomInfo name="whg_playbook_req_y_n" criteria="EQUALS">No</FilterByCustomInfo>

**********OUTPUT XML**********************

<ErrorInformation>

          <Severity>FATAL</Severity>

          <Description>Project Object read failed</Description>

          <Exception><![CDATA[SQL Exception with error code : 904]]></Exception>

        </ErrorInformation>

**********OUTPUT XML**********************


This doesnt seem to work. Could you please advise if this is possible via XOG?

Environment

Release : 15.5

Component : CA PPM SAAS XML OPEN GATEWAY (XOG)

Resolution

whg_playbook_req_y_n is custom boolean attribute and should have values of 0 or 1 in the FilterByCustomInfo, once we changed Filter value to 1 we were able to XOG out projects. Before customer was using "No" for the filter which was not correct.