JDBC Driver for WooCommerce

Build 24.0.9062

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.

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