Cmdlets for BigCommerce

Build 20.0.7654

OrderMessages

Gets the messages associated with an order.

Table Specific Information

Select

The {i 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 {i.

  • 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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654