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>