AnsweredAssumed Answered

Problem with custom object and read from xog

Question asked by sven.steiger on Feb 3, 2012
Latest reply on Feb 10, 2012 by Chris_Hackett
Hallo Community,

We created a custom object z_skill_edit

With the following XOG code I get all skills returned


XML-Code:
<?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="8.0" action="read" objectType="customObjectInstance" externalSource="NIKU"/>
<CustomObjectInstanceQuery>
<Filter name="objectCode" criteria="EQUALS">z_skill_edit</Filter>
</CustomObjectInstanceQuery>
</NikuDataBus>


Result
<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_customObjectInstance.xsd">
<Header action="write" externalSource="NIKU"
objectType="customObjectInstance" version="12.1.1.1208"/>
<customObjectInstances objectCode="z_skill_edit">
<instance instanceCode="ES00000047" objectCode="z_skill_edit"
parentInstanceCode="v0159" parentObjectCode="resource">
<CustomInformation>
<ColumnValue name="z_skill_name">0101 English</ColumnValue>
<ColumnValue name="z_proficiency">1 - Basic knowledge</ColumnValue>
<ColumnValue name="z_parent_skill">Languages</ColumnValue>
<ColumnValue name="z_deletion">false</ColumnValue>
<ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>
<ColumnValue name="name">0101 English</ColumnValue>
<ColumnValue name="code">ES00000047</ColumnValue>
<ColumnValue name="odf_parent_id">5002115</ColumnValue>
<ColumnValue name="odf_cncrt_parent_id">5002115</ColumnValue>
<ColumnValue name="z_skill_id">5000001</ColumnValue>
<ColumnValue name="z_status">0</ColumnValue>
<ColumnValue name="z_notified">true</ColumnValue>
</CustomInformation>
<OBSAssocs completed="false"/>
<Security>
<UserSecurity rightCode="odf_cst_z_skill_edit_edit" userName="v0159"/>
</Security>
</instance>
<instance instanceCode="ES00000100" objectCode="z_skill_edit"
parentInstanceCode="c0297" parentObjectCode="resource">
<CustomInformation>
<ColumnValue name="z_skill_name">0103 Spanish</ColumnValue>
<ColumnValue name="z_proficiency">1 - Basic knowledge</ColumnValue>
<ColumnValue name="z_parent_skill">01 Languages</ColumnValue>
<ColumnValue name="z_deletion">false</ColumnValue>
<ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>
<ColumnValue name="name">0103 Spanish</ColumnValue>
<ColumnValue name="code">ES00000100</ColumnValue>
<ColumnValue name="odf_parent_id">5000010</ColumnValue>
<ColumnValue name="odf_cncrt_parent_id">5000010</ColumnValue>
<ColumnValue name="z_skill_id">5000003</ColumnValue>
<ColumnValue name="z_status">3</ColumnValue>
<ColumnValue name="z_notified">true</ColumnValue>
</CustomInformation>
<OBSAssocs completed="false"/>
<Security>
<UserSecurity rightCode="odf_cst_z_skill_edit_edit" userName="admin"/>
</Security>
</instance>
<instance instanceCode="ES00000104" objectCode="z_skill_edit"
parentInstanceCode="test_evo_empl" parentObjectCode="resource">
<CustomInformation>
<ColumnValue name="z_skill_name">0708 LotusScript</ColumnValue>
<ColumnValue name="z_proficiency">3 - Advanced</ColumnValue>
<ColumnValue name="z_parent_skill">07 Programming and Modelling Languages</ColumnValue>
<ColumnValue name="z_deletion">false</ColumnValue>
<ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>
<ColumnValue name="name">0708 LotusScript</ColumnValue>
<ColumnValue name="code">ES00000104</ColumnValue>
<ColumnValue name="odf_parent_id">5001011</ColumnValue>
<ColumnValue name="odf_cncrt_parent_id">5001011</ColumnValue>
<ColumnValue name="z_skill_id">5000118</ColumnValue>
<ColumnValue name="z_status">0</ColumnValue>
<ColumnValue name="z_notified">true</ColumnValue>
</CustomInformation>
<OBSAssocs completed="false"/>
<Security>
<UserSecurity rightCode="odf_cst_z_skill_edit_edit" userName="test_evo_empl"/>
</Security>
</instance>
.............
</customObjectInstances>
<XOGOutput>
<Object type="customObjectInstance"/>
<Status state="SUCCESS"/>
<Statistics failureRecords="0" insertedRecords="0"
totalNumberOfRecords="xx" updatedRecords="0"/>
<Records/>
</XOGOutput>
</NikuDataBus>


-------------------
This works fine in the development system. In the productive environment, we have much more of these Object instances, so the XOG ends in a TCP timeout.
Now I tried to enhance the filter, so that I only get the language skills by using

<Filter name="z_parent_skill" criteria="EQUALS">01 Languages</Filter>

This does not work. I need an idea to include the ColumnValue into the filter.

Many tanks for your help

Outcomes