def _get_case_case_counts_by_owner(domain, datespan, case_types, is_total=False, owner_ids=None, export=False): es_instance = ES_EXPORT_INSTANCE if export else ES_DEFAULT_INSTANCE case_query = (CaseES( es_instance_alias=es_instance).domain(domain).opened_range( lte=datespan.enddate.date()).NOT( closed_range_filter( lt=datespan.startdate.date())).terms_aggregation( 'owner_id', 'owner_id').size(0)) if case_types: case_query = case_query.filter({"terms": {"type.exact": case_types}}) else: case_query = case_query.filter( filters.NOT(case_type_filter('commcare-user'))) if not is_total: case_query = case_query.active_in_range( gte=datespan.startdate.date(), lte=datespan.enddate.date(), ) if owner_ids: case_query = case_query.owner(owner_ids) return case_query.run().aggregations.owner_id.counts_by_bucket()
def _get_case_case_counts_by_owner(domain, datespan, case_types, is_total=False, owner_ids=None): case_query = ( CaseES() .domain(domain) .opened_range(lte=datespan.enddate) .NOT(closed_range_filter(lt=datespan.startdate)) .terms_aggregation("owner_id", "owner_id") .size(0) ) if case_types: case_query = case_query.filter({"terms": {"type.exact": case_types}}) else: case_query = case_query.filter(filters.NOT(case_type_filter("commcare-user"))) if not is_total: case_query = case_query.active_in_range(gte=datespan.startdate, lte=datespan.enddate) if owner_ids: case_query = case_query.owner(owner_ids) return case_query.run().aggregations.owner_id.counts_by_bucket()
def _get_case_case_counts_by_owner(domain, datespan, case_types, is_total=False, owner_ids=None): case_query = (CaseES() .domain(domain) .opened_range(lte=datespan.enddate) .NOT(closed_range_filter(lt=datespan.startdate)) .terms_aggregation('owner_id', 'owner_id') .size(0)) if case_types: case_query = case_query.filter({"terms": {"type.exact": case_types}}) else: case_query = case_query.filter(filters.NOT(case_type_filter('commcare-user'))) if not is_total: case_query = case_query.active_in_range( gte=datespan.startdate, lte=datespan.enddate ) if owner_ids: case_query = case_query.owner(owner_ids) return case_query.run().aggregations.owner_id.counts_by_bucket()
def _get_case_case_counts_by_owner(domain, datespan, case_types, is_total=False, owner_ids=None, export=False): es_instance = ES_EXPORT_INSTANCE if export else ES_DEFAULT_INSTANCE case_query = (CaseES(es_instance_alias=es_instance) .domain(domain) .opened_range(lte=datespan.enddate) .NOT(closed_range_filter(lt=datespan.startdate)) .terms_aggregation('owner_id', 'owner_id') .size(0)) if case_types: case_query = case_query.filter({"terms": {"type.exact": case_types}}) else: case_query = case_query.filter(filters.NOT(case_type_filter('commcare-user'))) if not is_total: case_query = case_query.active_in_range( gte=datespan.startdate, lte=datespan.enddate ) if owner_ids: case_query = case_query.owner(owner_ids) return case_query.run().aggregations.owner_id.counts_by_bucket()