Last Updated:
June 10, 2021
by
Jesse Langstaff
| Version: 11
| 1,609 views
| 0 followers
members are following updates on this item.
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.
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