def get_query_value(year, quarter): spec = { "type": "quarter", "field": "modified_on_field", "slug": "my_slug", "display": "date Modified", } reports_core_filter = ReportFilterFactory.from_spec(spec) reports_core_value = reports_core_filter.get_value({ "my_slug-year": year, "my_slug-quarter": quarter }) return create_filter_value(spec, reports_core_value).to_sql_values()
def get_query_value(compare_as_string): spec = { "type": "date", "field": "modified_on_field", "slug": "my_slug", "display": "date Modified", "compare_as_string": compare_as_string, } reports_core_filter = ReportFilterFactory.from_spec(spec) reports_core_value = reports_core_filter.get_value({ "my_slug-start": "2015-06-07", "my_slug-end": "2015-06-08", "date_range_inclusive": True, }) return create_filter_value(spec, reports_core_value).to_sql_values()
def set_filter_values(self, filter_values): for filter_slug, value in filter_values.items(): raw_filter_spec = self._filters[filter_slug] self._filter_values[filter_slug] = create_filter_value( raw_filter_spec, value)
def set_filter_values(self, filter_values): for filter_slug, value in filter_values.items(): raw_filter_spec = self._filters[filter_slug] self._filter_values[filter_slug] = create_filter_value(raw_filter_spec, value)