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.
Historical Number
FAQ3617
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21518688