
Hey there o/
Just a quick sidenote - Recently joined the student program and i'm loving what appwrite is providing me with. It's an amazing backend, but i'm also having a few pain points i would like to talk about.
I'm curious as to how one is supposed to do a not in
query. For example, imagine i have two collections with a one sided relation between them.
Collection A has some product data, Collection B has a description and score for a product in the A collection and that B record belongs to a user. (basically, a user can only grade a product from the A collection once)
My goal was to visualise this on the frontend and offer a nice ui for it, however due to my lack of knowledge (since i'm still a student) and no previous experience with such document databases (even though we are on top of mariadb), i found it incredibly difficult to do so.
I had to basically walk over the entire B table, retrieving records that belonged to the user, then proceded to retrive records from table A and discarding them on the frontend if any of them were already being pointed at by a record in B (since that would mean that the A records was already graded by a B record and there is nothing to do)

So here i am posting about this

Since i tried to search only for this. I was pretty sure that if there existed a query like Query.notequal('$id', [....all the ids i do not want to see.....])
my life wouldve been a lot easier

But perhaps i'm way too used to relational databases and my approach is wrong

Could someone people give me a few pointers on what can be improved here because i feel so lost
Recommended threads
- CSV Not Importing
We don’t seem to having any luck importing a simple .csv file. The import function acts like it’s working but no data imports or is shown in the collection The...
- Appwrite Cloud Custom Domains Issue
I’m trying to configure my custom domain api.kondri.lt (CNAME pointing to appwrite.network., also tried fra.cloud.appwrite.io with no luck ) but encountering a ...
- Persistent 401 Unauthorized on all authe...
Hello, I'm facing a critical 401 Unauthorized error on my admin panel app and have exhausted all debugging options. The Problem: When my React app on localhos...
