ADO.NET Provider for BigCommerce

Build 23.0.8770

OrderMessages

Gets the messages associated with an order.

Table Specific Information

Select

The 本製品 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 本製品.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8770