OrderMessages
Gets the messages associated with an order.
Table Specific Information
Select
The driver will use the BigCommerce API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.
- Id supports the '=, <=, <, >=, >' comparison.
- OrderId supports the '=' comparison.
- CustomerId supports the '=' comparison.
- Status supports the '=' comparison.
- IsFlagged supports the '=' comparison.
- DateCreated supports the '=, <=, <, >=, >' comparison.
For example, the following queries are processed server side:
SELECT * FROM OrderMessages SELECT * FROM OrderMessages WHERE Id = 1 SELECT * FROM OrderMessages WHERE OrderId = 2 SELECT * FROM OrderMessages WHERE IsFlagged = "true" SELECT * FROM OrderMessages WHERE DateCreated >= "2019-01-01" AND DateCreated <= "2020-01-01"
Columns
| Name | Type | Description |
| Id [KEY] | Integer | Numeric ID of this product within this order. |
| OrderId | Integer | Numeric ID of the associated order. |
| StaffId | Integer | The staff id. |
| CustomerId | Integer | The customer id. |
| Type | String | Type of the message. |
| Subject | String | Subject of the message. |
| Message | String | Message content. |
| Status | String | Status of the message. |
| IsFlagged | Boolean | Indicator if the message is flagged. |
| DateCreated | Datetime | Datetime when the message was first created. |