Web

Query Integeration Help

Dec 27, 2023, 19:56

View on Discord

Votes

Replies

Participants

Unknown

Messages

ShubhamOriginal post

Rank 3: Container

Aug 28, 2023, 15:51

I have a collection that has attribute named ids of type arrays , in ids some id will be store that will belong to it , i want to query this collection such that only that documents fetch in which any specific id containes in ids attribute , i will paas this id in input , how will i do that in react.

Summary

User is seeking help with integrating a query in their code. They shared a GitHub issue discussing the possibility of using `Query.search` but are unsure if it is officially supported. They mention that their collection has the correct permissions and indexing. They shared their code and mention that it's not working. They ask for assistance in querying their collection to fetch only the documents that contain a specific ID in the 'ids' attribute. There is a suggestion to use `Query.equal('ids', ['id1', 'id2', ...])` and another suggestion to create a separate field named 'search' with a 'fullText' index. There

Binyamin

Aug 28, 2023, 15:53

You can achieve that by creating another field named search and add fullText index to it

Binyamin

Aug 28, 2023, 15:53

Then add all the ID's to that field seperate by space.

Guille

Aug 28, 2023, 15:55

If I understood well you need to create a key index and use Query.equal('ids' ['id1', 'id2', '...'])

Guille

Aug 28, 2023, 15:55

@Binyamin Why you prefer fullText? 🤔

Binyamin

Aug 28, 2023, 15:56

Because I though he also liked to perform a search to find only one ID

Binyamin

Aug 28, 2023, 15:57

If the match looking is for all the IDs together then your solution is the right one.

Guille

Aug 28, 2023, 15:58

Yes, the description is not very clear, lets wait until he clarify what he is looking for

Shubham

Rank 3: Container

Aug 28, 2023, 16:04

Plain text

  "title": String ,
  "ids": Array[String],
  amount: Int
)```

Shubham

Rank 3: Container

Aug 28, 2023, 16:04

so when i pass any id in function , all document that contains this id in ids array should get

Guille

Aug 28, 2023, 16:06

TypeScript

const queries = [Query.equal('ids', [...])]
const response = await databases.listDocuments('DATABASE_ID', 'COLLECTION_ID', queries);

This is what you should do with the JS SDK

Shubham

Rank 3: Container

Aug 28, 2023, 18:09

its not working

Shubham

Rank 3: Container

Aug 28, 2023, 18:10

Plain text

  
  try {
    const queries = [Query.equal('ids', [id])]
    return database.listDocuments(databaseID, 
      collectionId,
      queries
      );
  } catch (e) {
    console.error(e.message);
  }
};```

Guille

Aug 28, 2023, 21:10

Do you get any error, or you just get an empty array?

Guille

Aug 28, 2023, 21:10

Does your collection or document have the correct permission?

Shubham

Rank 3: Container

Aug 29, 2023, 10:01

i got empty array

Shubham

Rank 3: Container

Aug 29, 2023, 10:02

My collection has proper permission , and indexing also

Guille

Aug 29, 2023, 21:14

Please check this, issue: https://github.com/appwrite/appwrite/issues/2838

Guille

Aug 29, 2023, 21:15

it seems like is not officially supported however the last comment says you can use Query.search

Query Integeration Help

Need support?_