[SOLVED]Searching user list by using Query.search via sdk throws an error
- 0
- Self Hosted
- Auth
- General

Hi everyone, I have a function which takes two optional parameters username and label and returns a list of users. It runs fine when i pass nothing to it and returns the whole list of my users. However when i pass a letter to the username parameter, it fails with server error. Below is the python code i am using to retreive the users:```def fetch_taggable_users(context, client): try: users = Users(client) # Parse the request body request_body = json.loads(context.req.body) if context.req.body else {} context.log(json.dumps(request_body, indent=4)) username = request_body.get('username', '') label = request_body.get('label', '')
# Construct the query based on the request parameters
query = [Query.equal('emailVerification', True), Query.equal('status', True)]
if username:
context.log(f"username is present {username}")
query.append(Query.search('name', username))
if label:
context.log(f"label is present {label}")
query.append(Query.equal('label', label))
# Retrieve the list of users
users_list = users.list(queries=query)
simplified_users = [{'$id': user['$id'], 'name': user['name']} for user in users_list['users']]
# Log and return the simplified user list
context.log(json.dumps(simplified_users, indent=4))
return context.res.json(simplified_users)
except Exception as e:
# Log the error and return a 500 server error response
error_message = f"An error occurred: {str(e)}"
context.log(error_message)
return context.res.json({'error': error_message})``` As you can see i am using Query.search to retrieve the list of users which will be used on the frontend to implement a mention system. I dont know how i can create an index for fulltext search on the name attribute of Users...

First to make sure you're using the right sdk, what's your self-hosted appwrite version and the SDK version you're using?

@Ernest i am using appwrite 1.5.4 and the python sdk i dint specify a version in the requirement file.

But i seem to have figured it out, ther is a search parameter on the users.list function . When i use that i get the proper result i am looking for

ill mark this as solved...Thanks for helping out

[SOLVED]Searching user list by using Query.search via sdk throws an error
Recommended threads
- ENV vars not updating
When i do `nano .env` it shows `_APP_DOMAIN_TARGET=` as set to my domain, but when i do `docker compose exec appwrite vars` it shows `_APP_DOMAIN_TARGET=` as ...
- Index with the requested key already exi...
I'm using appwrite cli to create DB and I'm getting index_already_exists Is there a way to undestand the index name and maybe to skip if it's already exits?
- Issue - Migration From Cloud > Self Host...
Hi team, I’m trying to migrate a few of my Appwrite projects from the cloud to a self-hosted instance. These projects are currently in “archive mode” due to th...
