[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
- OAuth session cookie is set but wont del...
I have made it so my users can log in with Github, and it does work, however when I try and get their details with account.get() I get the error ```AppwriteExce...
- appwrite-worker-usage invalid character ...
```bash root@appwrite:~# docker logs appwrite-worker-usage ... ... [Job] Received Job (6639ff2e219529.60314462). [2024-05-07 10:15:10.139] Aggregated 207 keys [...
- How can i get a user role label from aut...
So i am trying to make a different layout for admins and regular users, and couldnt find a way to get the user role. I tried looking on the internet but so far ...