🚀 Feature: "Query" Database by permissions

[nimos-dev]

🔖 Feature description

Extend the functionality of: Database List Documents (get a list of all the user's documents in a given collection.)

Suggestions:

List Documents(X) Get a list of all the user's documents in a given collection where user has permissions X;

List Documents(Read) (Get a list of all the user's documents which the user has read permissions)
List Documents(Read/Write) (Get a list of all the user's documents which the user has read/write permissions)
List Documents(Read/Write/Delete) ( Get a list of all the user's documents which the user has read/write/Delete permissions)

🎤 Pitch

Today we can List Documents (get a list of all the user's documents in a given collection.) which in practice means all documents to which the user has read rights. It would be nice if you could get all documents based on what permissions the user have. Today you have to implement extra redundant attributes if we want to sort/querry by permission.

Examples of areas of use are content moderation.

Not a critical feature but something that would help avoid boilerplate code and redundant attributes which improves code quality and reduces the risk of errors. Today, when I give a user write rights, I have to both update permissions and then also an attribute field to be able to sort/querry based on whether the user has write permissions or not.

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[stnguyen90]

@nimos-dev, thanks for creating this issue! 🙏🏼

[dhonig-weizmann]

upvoted :)

Is there any workaround I can use in the meantime?

I tried to use
Query.contains('\$permissions', 'read("user:$subjectId")') but I get an error Attribute not found in schema: $permissions
Using dart_appwrite version 11.0.3

Any help would be most appreciated