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


CData JDBC Driver for Magento 2019 - Build 19.0.7354

Query the available order addresses in Magento.


The driver will use the Magento API to filter the results by the AddressType and OrderId columns while the rest of the filter is executed client side within the driver. You must specify the OrderId column in the WHERE clause. The equals (=) operator on these columns is processed server side.

For example, the following query is processed server side:

SELECT * FROM OrderAddresses WHERE OrderId=183 AND AddressType='SHIPPING'
You can turn off client-side execution by setting SupportEnhancedSQL to false, in which case any search criteria that refers to other columns will cause an error.


Name Type Description
AddressType String Address type: SHIPPING or BILLING.

The allowed values are SHIPPING, BILLING.

OrderId String The Id of the order.
CreatedAt Datetime Order creation date.
Status String The status of the order.
Prefix String Customer prefix.
Email String Customer email address.
FirstName String The customer first name.
MiddleName String Customer middle name or initial.
LastName String The customer last name.
Suffix String Customer suffix.
Company String The customer company.
City String Name of the city.
CountryId String Country name.
Region String Region name.
Postcode String The website associated with the customer.
Telephone String Customer prefix.
Fax String Customer fax.
Street String The customer street address.

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