getting an empty list or error when try to query a document
The separator can be anything but I think a space would work best. Also, you should probably look into using a function to populate the composite attribute field of all existing data and even going forward.
yes i can confirm that as well i just now tryed in GraphQl the same with query.select it works.
this sounds to me alot work and complex somehow
i think this is maybe related to my issue https://github.com/appwrite/sdk-for-flutter/issues/173
What’s your code?
listDocuments( databaseId: Env.databaseId, collectionId: Env.locationsTableId, queries: [ Query.search('Name', query), Query.search('Addresse', query), Query.select(["Name", "Addresse"]), ]);
my code
Yes, that's the same bug
ok then for now i cant do anything then just wait for the bug to be fixed and wait for the implementation of the OR condition
So
OR works in certain conditions like
Query.equal(‘attribute”, [string1, string2, etc])
But if you just want to search for one thing
You can use the same trick I use
I have an Appwrite function that automatically finds any collection with a ‘search’ attribute and, when updated or created, JSON stringifies the object (minus the search field and any I don’t want searchable) into the search column which is then full text indexed
so when I search it’s one search value and I’m searching the whole thing
Do you think that would work here
no its not the solution for me but dont have any choice in my point of view.
yes i also want to search the whole collection if its possible but i thaught the way to do so would be like with Query.search operation and the same for all the fields
The whole collection yeah that’s how I did it
it’s not a complete solution, but also it actually is pretty nice IMO, it lets me be more selective about what I keep or don’t keep
yes this seams to be good solution but i didnt get it completely what to do. Maybe if you give me some more informations. <i would be very happy
Basically because you can only full text one attribute to search at a time, if you want to OR search something, make another attribute and whenever you update or create the other attributes, make that attribute just a JSON version of the attributes you want to search, then search that column
would it then work if i have json string in a column and search.
but i have also an idea. What if i search just one column at a time if i get empty list i search then the other colun automatically so it will be two searches.
