Retrieves all subscription notes. This table shows data only if the WooCommerce Subscriptions Plugin is enabled.

Table Specific Information

Select

WooCommerce supports server-side filtering only on a limited set of columns in the SubscriptionNotes table. All other filters are applied client-side. The following columns support server-side filtering with the specified operators:

• Id supports the '=' operator.
• SubscriptionId supports the '=' operator.

If the SubscriptionId filter is not specified, the add-in retrieves all subscriptions and performs an individual request for each related note. This can result in significantly slower queries.

The following example demonstrates a basic query with both filters:

-- Query a specific subscription note by ID and subscription
SELECT * FROM SubscriptionNotes WHERE Id = 4 AND SubscriptionId = 10

INSERT

The following columns are required when inserting records into the SubscriptionNotes table: SubscriptionId and Note.

-- Add a new note to a subscription
INSERT INTO SubscriptionNotes (Note, SubscriptionId) 
VALUES ('qwewq', 94)

Update

Update operations are not supported for the SubscriptionNotes table.

Delete

The following example demonstrates a basic delete operation using both columns:

-- Delete a note from a specific subscription
DELETE FROM SubscriptionNotes WHERE Id = 25 AND SubscriptionId = 45

Columns