Overview

Data Feeds tables will often contain rows and columns that aren't needed in your report. Often these will be rows for data outside your reporting period. It is best practice to apply filters to tables restricting how much data is being transmitted. This will result in improved performance of your custom reports.

Filters are applied to table attributes. Possible Filter operators can be found in OData's documentation.

Filter Examples

The following examples show how to apply filters to URLs. Your analytics tool may offer alternative filtering options.

Filter dContentBlog for 2018 posts:

https://{your community domain}/odata/dContentBlog?$filter=year(row_active_date) eq 2018

Filter dUtcHalfHour for January 2018 US Eastern time dates:

https://{your community domain}/odata/dUtcHourHour?$filter=month(us_eastern_dt) eq 1 and year(us_eastern_dt) eq 2018

Filter dUtcHalfHour for January 2018 to February 2018 US Eastern time dates:

https://{your community domain}/odata/dUtcHalfHour?$filter=month(us_eastern_dt) ge 1 and year(us_eastern_dt) ge 2018 and month(us_eastern_dt) le 2 and year(us_eastern_dt) le 2018