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(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 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)