OrderMessages
Gets the messages associated with an order.
Table Specific Information
Select
The driver uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=, <=, <, >=, >' comparison.
- OrderId supports the '=' comparison.
- CustomerId supports the '=' comparison.
- Status supports the '=' comparison.
- IsFlagged supports the '=' comparison.
- DateCreated supports the '=, <=, <, >=, >' comparison.
The rest of the filter is executed client-side within the driver.
For example, the following queries are processed server-side:
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 | References | 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. |