Troubleshooting
Problem
Attempts to run complex query on getItemList API is not working as expected in IBM Sterling Selling and Fulfillment.
Symptom
Steps to reproduce:
Run the below Input xml:
<Item OrganizationCode=t;ARGOSt; ItemGroupCode=t;PRODt; >
<PrimaryInformation KitCode=t;BUNDLEt; KitCodeQryType=t;NEt;>
<ComplexQuery Operator=t;ANDt;>
<And>
<Or>
<Exp Name=t;ProductLinet; Value=t;DOt; ProductLineQryType=t;EQt;/>
<Exp Name=t;ProductLinet; Value=t;Expertt; ProductLineQryType=t;EQt;/>
</Or>
<And>
</PrimaryInformation>
</ComplexQuery>
This leads to unexpected output.
Cause
The primary tag has to end before we begin the complexQuery tag element.
Resolving The Problem
The corrected input with a complex query for getItemList API is as follows:
<Item OrganizationCode=t;ARGOSt; ItemGroupCode=t;PRODt; >
<PrimaryInformation KitCode=t;BUNDLEt; KitCodeQryType=t;NEt;>
</PrimaryInformation>
<ComplexQuery Operator=t;ANDt;>
<And>
<Or>
<Exp Name=t;ProductLinet; Value=t;DOt; ProductLineQryType=t;EQt;/>
<Exp Name=t;ProductLinet; Value=t;Expertt; ProductLineQryType=t;EQt;/>
</Or>
<And>
</ComplexQuery>
</Item>
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21962269