Source code for


Here's an example adapted from the case list report - it gets a list of the ids
of all unknown users, web users, and demo users on a domain.

.. code-block:: python

    from import users as user_es

    user_filters = [

    query = (user_es.UserES()

    owner_ids = query.get_ids()
from copy import deepcopy

from . import filters, queries
from .es_query import HQESQuery

[docs]class UserES(HQESQuery): index = 'users' default_filters = { 'not_deleted': filters.term("base_doc", "couchuser"), 'active': filters.term("is_active", True), } @property def builtin_filters(self): return [ domain, created, mobile_users, web_users, user_ids, primary_location, location, last_logged_in, analytics_enabled, is_practice_user, role_id, is_active, username, metadata, ] + super(UserES, self).builtin_filters
[docs] def show_inactive(self): """Include inactive users, which would normally be filtered out.""" return self.remove_default_filter('active')
[docs] def show_only_inactive(self): query = self.remove_default_filter('active') return query.is_active(False)
[docs]def domain(domain, allow_mirroring=False): domains = [domain] if allow_mirroring: from corehq.apps.users.models import DomainPermissionsMirror source_domain = DomainPermissionsMirror.source_domain(domain) if source_domain: domains.append(source_domain) return filters.OR( filters.term("domain.exact", domains), filters.term("domain_memberships.domain.exact", domains) )
[docs]def analytics_enabled(enabled=True): if enabled: return filters.OR( filters.term("analytics_enabled", True), filters.missing("analytics_enabled") ) else: return filters.term("analytics_enabled", False)
[docs]def username(username): return filters.term("username.exact", username)
[docs]def web_users(): return filters.doc_type("WebUser")
[docs]def mobile_users(): return filters.doc_type("CommCareUser")
[docs]def unknown_users(): """ Return only UnknownUsers. Unknown users are mock users created from xform submissions with unknown user ids. """ return filters.doc_type("UnknownUser")
[docs]def admin_users(): """ Return only AdminUsers. Admin users are mock users created from xform submissions with unknown user ids whose username is "admin". """ return filters.doc_type("AdminUser")
[docs]def demo_users(): """Matches users whose username is demo_user""" return username("demo_user")
[docs]def created(gt=None, gte=None, lt=None, lte=None): return filters.date_range('created_on', gt, gte, lt, lte)
[docs]def last_logged_in(gt=None, gte=None, lt=None, lte=None): return filters.date_range('last_login', gt, gte, lt, lte)
[docs]def user_ids(user_ids): return filters.term("_id", list(user_ids))
[docs]def primary_location(location_id): # by primary location return filters.OR( filters.AND(mobile_users(), filters.term('location_id', location_id)), filters.AND( web_users(), filters.term('domain_memberships.location_id', location_id) ), )
[docs]def location(location_id): # by any assigned-location primary or not return filters.OR( filters.AND(mobile_users(), filters.term('assigned_location_ids', location_id)), # todo; this actually doesn't get applied since the below field is not indexed filters.AND( web_users(), filters.term('domain_memberships.assigned_location_ids', location_id) ), )
[docs]def is_practice_user(practice_mode=True): return filters.term('is_demo_user', practice_mode)
[docs]def role_id(role_id): return filters.OR( filters.term("domain_membership.role_id", role_id), # mobile users filters.term("domain_memberships.role_id", role_id) # web users )
[docs]def is_active(active=True): return filters.term("is_active", active)
[docs]def metadata(key, value): # Note that this dict is stored in ES under the `user_data` field, and # transformed into a queryable format (in ES) as `user_data_es`, but it's # referenced in python as `metadata` return queries.nested( 'user_data_es', filters.AND( filters.term(field='user_data_es.key', value=key), queries.match(field='user_data_es.value', search_string=value, fuzziness=0), ) )