OrderComments
OrderComments is an auto generated table. The supported operations are Insert, and Querying data from this table.
Table Specific Information
Select
The connector uses the AdobeCommerce API to filter the results by Id while the rest of the filter is executed client side within the connector.
You must specify the Id column in the WHERE clause to retrieve results from OrderComments. Id can be used only with the equals (=) operator.
For example:
SELECT * FROM [OrderComments] WHERE Id = '123'
INSERT
To create a new OrderComment, Id, Comment and ParentId are required.
INSERT INTO OrderComments(Comment,Id,ParentId) VALUES('ABdCdwawD',2,2)
Columns
| Name | Type | ReadOnly | Description |
| Comment | String | False |
Comment. |
| Id | String | False |
id |
| CreatedAt | Datetime | False |
Created-at timestamp. |
| EntityId [KEY] | Int | False |
Order status history ID. |
| EntityName | String | False |
Entity name. |
| ExtensionAttributes | String | False |
This is an auto-generated column |
| IsCustomerNotified | Int | False |
Is-customer-notified flag value. |
| IsVisibleOnFront | Int | False |
Is-visible-on-storefront flag value. |
| ParentId | Int | False |
Parent ID. |
| SearchCriteria | String | False |
This is an auto-generated column |
| Status | String | False |
Status. |
| TotalCount | Int | False |
Total count. |