OrderComments
OrderComments is an auto generated table. The supported operations are Insert, and Querying data from this table.
Table Specific Information
Select
The add-in uses the AdobeCommerce API to filter the results by Id while the rest of the filter is executed client side within the add-in.
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. |