skavankOriginal post
Rank 2: Process
Hey!
Since we don't have any way to do conditional document access, we have to lock down all permissions and roll our own APIs.
Now I'm having another problem, since we cannot do OR queries, we might not be able to achieve optimal document fetching even server-side.
Take this basic example:
We want to get all documents from a collection, that is either non-private or owned by the user.
Pseudo SQL:
TypeScript
SELECT * FROM Posts WHERE status !== 'private' OR $user.id == ownerIs there a way to achieve this?
Summary
Currently, there is no support for OR queries in the Appwrite platform. This limitation prevents optimal document fetching even server-side. One possible solution is to lock down all permissions and create custom APIs to handle conditional document access. However, this workaround may not be ideal. For more information and updates on this issue, you can check the following link: https://github.com/appwrite/appwrite/issues/2740.