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

OrderComments

CData JDBC Driver for Magento 2019 - Build 19.0.7354

Query the available order comments in Magento.

Select

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 following query is processed server side:

SELECT * FROM OrderComments WHERE OrderId=183
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.

Columns

Name Type Description
Comment String Comment text.
OrderId String The Id of the order.
CreatedAt Datetime Date when the comment was added.
IsCustomerNotified Boolean Defines whether the customer is notified about the comment. Can have the following values: False - Customer is not notified or True - Customer is notified.

The allowed values are False, True.

IsVisibleOnFront Boolean Defines whether the comment is visible on the frontend. Can have the following values: False - Comment is not visible or True - Comment is visible.

The allowed values are False, True.

Status String Comment status.

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