Question & Answer
Question
Usage of complex queries.
Answer
Listing some of the examples.
a)For a question from customer:
I am trying to Create a Service which gives me the list of Orders(
getOrderList) which are created between 2008-11-28 and 2008-11-30 and which
have payment Status stuck in INVOICED and which has Payment Type as Credit
Card.
.
Answer :
<Order
OrderDateQryType="DATERANGE" FromOrderDate="20081128"
<PaymentMethod
PaymentType="Credit Card" />
<Order/>
b) When customer is writing a custom agent and wants to get a list of shipments which the agent can process.He can get the list using getShipmentList for the following input
<Shipment ShipmentKeyQry=”GT” ShipmentKey=”LastProcessedShipmentKey” EnterpriseCode='DEFAULT' Status='1100.70'/>
In agent servers framework we get a last message processed from the system.The input for ShipmentKey is refering to that value.
c)For getting a specific departments within a organization code the following complex query input can be used
<Organization MaximumRecords="5000"
OrganizationCode="DEFAULT">
<DepartmentList>
<Department>
<ComplexQuery Operator="AND">
<And>
<Exp Name="DepartmentCode"
Value="DEPT_001"/>
</And>
</ComplexQuery>
</Department>
</DepartmentList>
</Organization>
Historical Number
HTG2018
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21563507