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