SiteFileDownloads
Query the SiteFileDownloads in Wordpress.
Table Specific Information
SELECT
The connector uses the WordPress API to process some of the filters.
- Date supports the '=' comparison.
- Period supports the '=' comparison.
- HasSummarize supports the '=' comparison.
- NumofPeriods supports the '=' comparison.
The connector processes other filters client-side within the connector.
For example, the following queries are processed server side.
SELECT * FROM SiteFileDownloads WHERE Date='2025-05-08'
Columns
| Name | Type | References | Description |
| Date | Date | The most recent date for which file download statistics are available. | |
| DaysAggregate | String | An array that maps each day to the number of file downloads recorded on that date. | |
| Period | String | Specifies the reporting interval for the statistics, such as day, week, month, or year.
The allowed values are day, month, week, year. | |
| SummaryAggregate | String | A summarized dataset combining file downloads statistics across all days in the selected period. Returned only when summarize is true. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| NumofPeriods | Int | Determines how many reporting periods to include in the returned results. | |
| HasSummarize | Boolean | Indicates whether the SiteFileDownloads results include summarized data. |