IBM Support

Complex Query on getItemList API not working as expected

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>

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.0","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21962269

Page Feedback