IBM Support

Complex query: Sterling MCF 8.0 supports ELIKE parameter as a query type.

Question & Answer


Question

Complex query: Sterling MCF 8.0 supports ELIKE parameter as a query type.

Answer

Sterling MCF 8.0 supports ELIKE parameter as a query type for complex queries.

For example: For a sample input XML for the getShipmentList API as shown below:

<Shipment DocumentType="0005" MaximumRecords="5000" ReceivingNode="ABC">
<ComplexQuery Operator="AND">
<And>
<Exp Name="Extn_UnitNo" QryType="FLIKE" Value="TOLU"/>
<Exp Name="Extn_UnitNo" QryType="ELIKE" Value="4"/>
</And>
</ComplexQuery>
</Shipment>

The SQL statement generated is:

Select EXTN_UNIT_NO from yfs_shipment where EXTN_UNIT_NO LIKE 'TOLU%' and EXTN_UNIT_NO LIKE '%4' ;

Hence the ELIKE query type compares any characters prefixed to the condition value.

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

Historical Number

FAQ3617

Document Information

Modified date:
16 June 2018

UID

swg21518688

Page Feedback