TotalsReport
Execute a totals report.
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 columns for this
table are: ReportType, StartDate, EndDate. All other columns are processed client side.
SELECT * FROM TotalsReport WHERE ReportType = 'reviews' AND StartDate = '01/01/2019'
Columns
Name | Type | References | Description |
Slug | String | An alphanumeric identifier for the resource. | |
Name | String | Review type name. | |
Total | String | Amount of reviews. | |
ReportType | String | Type of the report. Must be one of: reviews, products, orders, customers, coupons. | |
StartDate | Date | Return the report for a specific start date. | |
EndDate | Date | Return the report for a specific end date. |