OrderItemOptionValues

Returns data from OrderItems table.

Table Specific Information

The driver uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

The rest of the filter is executed client-side within the driver.

For example, the following queries are processed server-side:

SELECT * FROM [OrderItemOptionValues] WHERE OrderItemId = 2522;
SELECT * FROM [OrderItemOptionValues] WHERE OrderId = 100 and OrderItemId = 27;


Name	Type	References	Description
Id [KEY]	Integer		The numerical ID of the option value within the group of ordered items.
OptionId	Integer	ProductOptions.Id	The ID of the option from Product Options table.
OrderItemId [KEY]	Integer	OrderItems.Id	The ID of the product.
OrderItemOptionId	Integer		The numerical ID of the option within the group of ordered items.
DisplayName	String		The name of the option shown on the storefront.
DisplayValue	String		The value of the option shown on the storefront.
Value	String		The actual value of the option.
Name	String		The unique option name, auto-generated from the display name, a timestamp, and the product ID.
Type	String		The type of option, which determines how it will display on the storefront. Acceptable values: Checkbox \| Date field \| File Upload \| Multi-line text field \| Multiple choice \| Product Pick List \| Swatch \| Text field
DisplayStyle	String		The specific style which the order will be displayed as.
OrderId	Integer		Numeric ID of the associated order.
OrderProductId	Integer		Order product Id
DisplayNameCustomer	String		The product option name that is shown to customer in storefront.
DisplayNameMerchant	String		The product option name that is shown to merchant in Control Panel.
DisplayValueCustomer	String		The product option value that is shown to customer in storefront.
DisplayValueMerchant	String		The product option value that is shown to merchant in Control Panel.