OrderComments
OrderComments is an auto generated table. The supported operations are Insert, and Querying data from this table.
Table Specific Information
Select
The 本製品 will use the AdobeCommerce API to filter the results by Id while the rest of the filter is executed client side within the 本製品.
The Id column must be specified 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. |