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. |