JDBC Driver for WooCommerce

Build 24.0.9062

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 本製品 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 References Description
Id [KEY] Long 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 False

Orders.Id

Id of the order.

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