Querying Members

The queryMembers endpoint allows you to list and paginate members for a channel. The endpoint supports filtering on numerous criteria to efficiently return member information. This endpoint is useful for channels that have large lists of members and you want to search members or if you want to display the full list of members for a channel.

Pagination and ordering

By default members are ordered from oldest to newest and can be paginated using offset-based pagination or by created_at or user_id fields.

Pagination by offset is the simplest to implement but it can lead to incorrect results if the list of members changes while you are paginating.

The recommended approach is to sort by “created_at” or by “user_id”.

val channelClient = client.channel("messaging", "general")
val filter = Filters.neutral()
val offset = 0
val limit = 10

// paginate by user_id in descending order
val sort = QuerySortByField<Member>().descByName("userId")

channelClient.queryMembers(offset, limit, filter, sort).enqueue { result ->
  if (result.isSuccess) {
    val members: List<Member> = result.data()
  } else {
    Log.e(TAG, String.format("There was an error %s", result.error()), result.error().cause)
  }
}

// paginate by created at in ascending order
val createdAtSort = QuerySortByField<Member>().ascByName("createdAt")

channelClient.queryMembers(offset, limit, filter, createdAtSort).enqueue { result ->
  if (result.isSuccess) {
    val members: List<Member> = result.data()
  } else {
    Log.e(TAG, String.format("There was an error %s", result.error()), result.error().cause)
  }
}

Stream Chat does not run MongoDB on the backend, only a subset of the query options are available.

Here’s some example of how you can query the list of members:

// query members by user.name
channel.queryMembers(
 filter: Filter.equal('name': 'tommaso'),
);

// autocomplete members by user name
channel.queryMembers(
 filter: Filter.autocomplete('name', 'tomm'),
);

// query member by id
channel.queryMembers(
 filter: Filter.equal('id', 'tommaso'),
);

// query multiple members by id
channel.queryMembers(
 filter: Filter.in_('id', ['tommaso', 'thierry']),
);

// query channel moderators
channel.queryMembers(
 filter: Filter.equal('is_moderator', true),
);

// query for banned members in channel
channel.queryMembers(
 filter: Filter.equal('banned', true),
);

// query members with pending invites
channel.queryMembers(
 filter: Filter.equal('invite', 'pending'),
);

// query all the members
channel.queryMembers();

// paginate channel members
channel.queryMembers(
 pagination: PaginationParams(
  limit: 10,
  offset: 10,
 ),
);

// order results by member created at descending
channel.queryMembers(
 sort: [
  SortOption(
   'created_at', direction: SortOption.DESC,
  ),
 ],
);

// query for user.email (currently the only supported custom field)
channel.queryMembers(
 filter: Filter.equal('email', 'marcelo@getstream.io'),
);

Query Parameters

nametypedescriptiondefaultoptional
filtersobjectThe query filters to use. You can query on any of the custom fields defined above{}
sortobjectthe sort parameters{ created_at:1}
optionsobjectpagination options{ limit:100, offset:0}

By default when query members does not have any filter and it will match all members on your channel.

Member Queryable Built-In Fields

The following fields can be used to filter your query results

NameTypeDescriptionsupported operatorsExample
idstringthe id of the user$eq $intom
namestringthe name of the user$eq, $in, $autocomplete, $qTommaso
channel_rolestringthe member role$eqchannel_moderator
bannedbooleanthe banned status$eqfalse
invitestring, must be one of these values: (pending, accepted, rejected)the status of the invite$eqpending
joinedbooleanwhether member is joined the channel or not$eqtrue
created_atstring, must be formatted as an RFC3339 timestampthe time that the member was created$eq, $gt, $gte, $lt, $lte2021-01-15T09:30:20.45Z
updated_atstring, must be formatted as an RFC3339 timestampthe time the member was last updated$eq, $gt, $gte, $lt, $lte2021-01-15T09:30:20.45Z
last_activestring, must be formatted as an RFC3339 timestampthe time the user was last active$eq, $gt, $gte, $lt, $lte2021-01-15T09:30:20.45Z
cidstringthe cid of the channel that the user is a member of$eqmessaging:general
user.emailstringthe ‘email’ property of the user$eq, $in, $autcompleteuser@example.com

Also, you can pass any field available in the custom data.

Query Options

nametypedescriptiondefaultoptional
limitintegerThe number of members to return (max is 100)100
offsetintegerThe offset (max is 1000)0
user_id_ltstringPagination option: excludes members with ID greater or equal the value-
user_id_ltestringPagination option: excludes members with ID greater than the value-
user_id_gtstringPagination option: excludes members with ID less or equal the value-
user_id_gtestringPagination option: excludes members with ID less than the value-
created_at_afterstringPagination option: select members created after the date (RFC399)-
created_at_beforestringPagination option: select members created before the date (RFC399)-
created_at_before_or_equalstringPagination option: select members created before or equal the date (RFC399)-
created_at_after_or_equalstringPagination option: select members created after or equal the date (RFC399)-

Response

Field NameDescription
membersThe list of members matching the query
© Getstream.io, Inc. All Rights Reserved.