Hi David,
Thanks for that feedback. Based on your response, I tried this:
<?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">charge_code_parents</Filter>
<Filter name="instanceCode" criteria="OR">odf_ca_charge_code_parents.code</Filter>
</CustomObjectInstanceQuery>
</NikuDataBus>
And the result was this:
-<NikuDataBus xsi:noNamespaceSchemaLocation="../xsd/nikuxog_customObjectInstance.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Header version="15.3.0.200" objectType="customObjectInstance" externalSource="NIKU" action="write"/>
<customObjectInstances objectCode="charge_code_parents"/>
-<XOGOutput>
<Object type="customObjectInstances"/>
<Status state="SUCCESS"/>
<Statistics updatedRecords="0" totalNumberOfRecords="0" failureRecords="0" insertedRecords="0"/>
<Records/>
</XOGOutput>
</NikuDataBus>
Even though there are 9 records in that table, so I was expecting 9 "rows" of output. Could it be case-sensitivity in the value I provided (odf_ca_charge_code_parents.code) for instanceCode?
(NOTE: I had to include instanceCode in the filter to avoid the SQL 936 error. If I remarked out that row, or deleted it entirely, I got the SQL 936 error.)
Getting closer, at least ...