CData JDBC Driver for Magento 2019 - Online Help
Questions / Feedback?


CData JDBC Driver for Magento 2019 - Build 19.0.7354

Query the available Items for a specific Order in Magento.


The driver will use the Magento API to filter the results by OrderId while the rest of the filter is executed client side within the driver. The following operators for the OrderId column are processed server side: >, >=, <, <=, =, IN, and NOT IN.

For example, the driver uses collaborative query processing to execute the following statement:

SELECT * FROM OrderItems WHERE OrderId=183 AND PriceInclTax > 30 AND PriceInclTax <=500 AND Name LIKE '%Alpaca%' AND Sku LIKE '_db%7'
You can turn off client-side execution by setting SupportEnhancedSQL to false, in which case any search criteria that refers to any other columns or operators will cause an error.


Name Type Description
ItemId [KEY] Integer The Id of the item.
OrderId [KEY] Integer The Id of the order.
ParentItemId Integer The Id of the parent item.
Sku String The SKU of the item.
Name String The name of the item.
Status String The status of the order.
CustomerId Integer Order customer Id.
CreatedAt Datetime Order creation date.
QtyCanceled Double Canceled quantity.
QtyInvoiced Double Invoiced quantity.
QtyOrdered Double Ordered quantity.
QtyRefunded Double Refunded quantity.
QtyShipped Double Shipped quantity.
Price Double Item price.
BasePrice Double Item base price.
OriginalPrice Double Item original price.
BaseOriginalPrice Double Item original base price.
TaxPercent Double Item tax percent
TaxAmount Double Item tax amount.
BaseTaxAmount Double Base tax amount.
DiscountAmount Double Discount amount.
BaseDiscountAmount Double Base discount amount.
RowTotal Double Row total.
BaseRowTotal Double Base row total.
PriceInclTax Double Price including tax.
BasePriceInclTax Double Base price including tax.
RowTotalInclTax Double Row total including tax.
BaseRowTotalInclTax Double Base row total including tax.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0