Example Query Directives
<Command type="Query"> <StartCount>5</StartCount> <MaxCount>50</MaxCount> <!-- Sample OrderByColumnList syntax is --> <!--<OrderByColumnList>AttributeName1,DESC:AttributeName2,ASC:AttributeName3</OrderByColumnList> --> <!-- Order can be ASC or DESC, and is optional. Default being ASC --> <OrderByColumnList>PRODUCTID, DESC:CustName, ASC:AmtPaid</OrderByColumnList> <!-- Above sort order would first sort on records by 'PRODUCTID' in 'DESCENDING' order,then further sort the results obtained by previous sort by 'CustName' in 'ASCENDING' order and lastly further sort the results by sorting on 'AmtPaid' in default 'ASCENDING' order. Results returned would be further filtered based on StartCount and MaxCount specified --> <MasterCatalogRecord etype="Entity"> <ExternalKeys> <!-- First Key is Master Catalog name --> <Key name="MASTERCATALOGNAME">CUSTOMER</Key> <Key name="PRODUCTID">cust_2</Key> </ExternalKeys> </MasterCatalogRecord> </Command>
Copyright © Cloud Software Group, Inc. All rights reserved.