ODBC Driver for WooCommerce

Build 20.0.7587

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 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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587