Query.contains not supported on Cloud?

I try to filter a row which contain a string inside a string array column, however I get the following error:

Is Query.contains() not supported on Cloud?

This is the code snippet:

    const queries = [
        Query.or([
            Query.contains('visibility', 'public'), // Include posts with public visibility
            Query.contains('visibility', currentUserId), // Include posts visible to the current user
        ]),
    ];

    try {
        return await ctx.backendClient.tablesDb.getRow<IPostsRow>({
            databaseId: CDBApp,
            queries,
            rowId: postId,
            tableId: ETable.Posts,
        });
    } catch (e) {
        ctx.error(JSON.stringify(e));
        throw new IKNotFoundError();
    }

The intent: Even if the post exists, it should only be returned if the user is allowed to see it according to the visibility

Maybe it's a problem with the tablesDB? It seems to work fine in the Users API

export default async function readSearchUsers({ ctx, query }: IReadSearchUsersOptions): Promise<TIdSchema[]> {
    const usersResultList = await ctx.backendClient.users.list({
        queries: [Query.contains('name', query)],
    });
    return usersResultList.users.filter((user) => !!user.name).map((user) => user.$id);
}

Not sure, but why not use document level permissions and then add the permissions via functions?

Permission.read(Role.any()) or Permission.read(Role.users())

or add user(s)

Permission.read(Role.user("5c1f88b42259e"))

or users with a specific labels

Permission.read(Role.label("coolclubonly"))

instead

Then you could call listRows without any queries and it will automatically return only the rows that users have permissions to access

Also, I don't think getRow should have queries since it's returning the specified ID despite it showing it in the web docs

https://appwrite.io/docs/references/cloud/client-web/tablesDB#getRow

In other words, either change it to listRows or don't include queries in getRow

because it was a PoC and things were different back then (needed different kind of functionality), however that doesn't solve the original problem...

Then please change the docs. I have to use them and rely on them to develop my application...

Thank you, I will rewrite it to permissions.

The title still stands, though. The docs say I can use queries, but they don't work as advertised 🙁

Or maybe queries in getRow is only reserved for Query.select

https://appwrite.io/docs/products/databases/queries#relationship-select

I'm a hobbyist (not on the appwrite team) but if you use listRows with Query.contains that should work for giving you multiple rows. getRow only returns the 1 row that has the id you specify, and if that's the case you can use Query.select to only return certain attributes/relationships in that 1 row.

Kinda hard to tell, but if you're looking for multiple posts in your response, your code should work with listRows instead of getRow

ah, sorry, I didn't see that. Yes, there might be many better ways, but I solved this one by writing JS to check the visibility. I have deadlines to meet, so just rewriting everything into a perfect state is not possible 😄