Multiple search for different attributes

Hi i want a search a user either by his name or phone number... How do i do that using Query.equal?

Searching of user can work only with the Users API with Server side SDK.
And that means you'll need either deploy Appwrite function or in any backend code you're using.

So, this function will let you to run the query against the users
https://appwrite.io/docs/server/users?sdk=nodejs-default#usersList

And the final code can be something similar to this (JavaScript snippet)

client
    .setEndpoint('https://cloud.appwrite.io/v1') // Your API Endpoint
    .setProject('5df5acd0d48c2') // Your project ID
    .setKey('919c2d18fb5d4...a2ae413da83346ad2') // Your secret API key
;

try {
  const users = await users.list([
    Query.equal("email", ["john@appwrite.io"]),
    Query.equal("phone", ["+1234567890"]),
  ]);

} catch (e) {
  // TODO: handle error
}

All query-able attributes can be found here in the user model
https://appwrite.io/docs/models/user

but i want to search a string in a attribute

Meaning?

for example i want to start searching for either name for phone number

it should work like Query.search("name", search) **OR** Query.search("phoneNumber", search)

Mmm. Got you

There is no option from what I know to do in Appwrite

hmm 😦

I think there some issue regards this one.

appwrite doesn't support OR operation in that case.

But the there is a workaround making two API calls

let searchUser = null;

try {
  // search by email
  searchUser = await users.list([
    Query.equal("email", ["john@appwrite.io"]),
  });

  // or search by phone
  if(!searchUser || searchUser.documents.length === 0) {
   searchUser = await users.list([
      Query.equal("phone", ["+1234567890"])
  }
} catch (e) {
  // handle error
}

do you specifically want to search through Users or your custom Collection?

You can upvote this issue

https://github.com/appwrite/appwrite/issues/5491

its custom collection

Ohh
Then just change the code to query the database instead

yeah but thats not an efficient approach i guess

im trying Query.search()

Updated it
It work the same

as i type the search box.. it should dynamically search name and phone number

This would be the related feature request then

as a workaround, you can create search attribute that has all the text you want to search against