ADO.NET Provider for WooCommerce

Build 20.0.7587

OrderNotes

Retrieve and modify the notes for an order.

Table Specific Information

Select

WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns support only the = comparison, unless stated otherwise. The available column for this table is: OrderId. All other columns are processed client side. If the 'OrderId' filter is not specified, the provider will fetch a list of all the orders and perform a request for each order in the list.

SELECT * FROM OrderNotes WHERE OrderId = 21

Insert

The following attributes are required when performing an insert: Note, OrderId.

INSERT INTO OrderNotes (Note, OrderId) VALUES ("note_text", 144)

Columns

Name Type ReadOnly Description
Id [KEY] Integer False

Unique identifier for the resource.

Author String True

Order note author.

DateCreated Datetime True

The date the order note was created, in the site's timezone.

Note String False

Order note content.

CustomerNote Boolean False

If true, the note will be shown to customers and they will be notified. If false, the note will be for admin reference only. Defaults to false.

AddedByUser Boolean False

If true, this note will be attributed to the current user. If false, the note will be attributed to the system. Defaults to false.

OrderId String True

Id of the order.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Type String

Limit result to customers or internal notes. Options: any, customer and internal. Defaults to any.

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