Database Operation Keyword "Query.contains()"

[humble rapids]

My app is a social App where user can follow and unfollow each other,
right now I don't know what i'm doing wrong but i want to be able to get posts of users if the user its contain in the array of user i'm following

Here is my Code

        databaseId: Common.dataBasesId,
        collectionId: Common.collectionStoryTellerId,
        queries: [
          Query.orderDesc('\$createdAt'),
          Query.limit(500),
          // Query.equal("userId", userId),
          Query.contains("userId", ['${userModel.following}']),
        ],
      );

  return doc.documents;

Please, what i'm missing out on?

[tidal spade]

you would use contains when the attribute is an array like:

{ 
   "followers": ["user1", "user2", "user3"]
}

Then, Query.contains("followers", ["user2"]) would match the document because followers contains user2

[plucky crescent]

Ooooh okay,

So @tidal spade what if the attribute it's not an array but the value to check with it's an array.

Let me give examples,
I have a collection called storyTeller and It has userId (string attributes) of people who created document in the collections.

And I have follower ( string array) and I want to check if any of my follower has made a post in the storyTeller collection

How do I do that?

[tidal spade]

It sounds like you want userId == follower1 OR userId == follower2 ...

If so, read this: https://appwrite.io/docs/products/databases/queries#building-queries

[plucky crescent]

Honestly @tidal spade I have read it, one of my tab is open on it,

I'm confused on how to go about this

[tidal spade]

What's confusing about:

For OR operation, pass multiple values into the query method separated by commas. For example Query.equal('title', ['Avatar', 'Lord of the Rings']) will fetch the movies Avatar or Lord of the Rings.

What do you think it means?

[humble rapids]

okay, thanks @tidal spade for putting more light into this

i did that i and i'm getting everything in the collection instead of just one document to be returned

This is my follower [2349034286339, 2348148422710]

only 2348148422710 have created a docement in the storyTeller Collection but instead i'm getting result of another,

what do i do here?

[tidal spade]

Share exact details like your code/ request that was made and the data in your collection

[humble rapids]

Here is the code

        databaseId: Common.dataBasesId,
        collectionId: Common.collectionStoryTellerId,
        queries: [
          // Query.equal("userId", userId),

          Query.orderDesc('\$createdAt'),
          Query.limit(500),
          Query.or([
            Query.equal("userId", ['${userModel.following}']),
            Query.isNotNull("userId")
          ]),
        ],
      );

 return doc.documents;

userModel.following contains [2349034286339, 2348148422710]

[tidal spade]

You put or is not null ..

[humble rapids]

okay,

Appwrite exception scream out me that at least two query its needed, and i dont know which query to use there

[tidal spade]

Don't use or...also you're not doing what's mentioned in the docs .....

[humble rapids]

@tidal spade please how do i proceed to get the desire result i want?

[tidal spade]

Read the docs more carefully

[humble rapids]

have multiple times

[tidal spade]

What is userModel.following? An array?

[humble rapids]

yes

[tidal spade]

Read this section again: https://appwrite.io/docs/products/databases/queries#building-queries

[humble rapids]

now i'm getting
AppwriteException: general_query_invalid, Invalid query: Query value is invalid for attribute "userId" (400)
whereas i have userId in the indexes

here is the code now

        databaseId: Common.dataBasesId,
        collectionId: Common.collectionStoryTellerId,
        queries: [
          // Query.equal("userId", userId),

          // Query.orderDesc('\$createdAt'),
          Query.limit(500),
          Query.or([
            Query.equal("userId", [userModel.following]),
          ]),
        ],
      );
    }

    return doc.documents;```

2. when i do it like this

        databaseId: Common.dataBasesId,
        collectionId: Common.collectionStoryTellerId,
        queries: [
          Query.orderDesc('\$createdAt'),
          Query.limit(500),
          Query.or([
            Query.equal("userId", ['${userModel.following}']), //attention here
          ]),
        ],
      );```


i get this error `AppwriteException: general_query_invalid, Invalid query: Or queries require at least two queries (400)`

what i'm i missing out here @tidal spade

[tidal spade]

Read the error message

[tidal spade]

Did you read the code sample at the bottom of this page?

[humble rapids]

ofcourse i did @tidal spade

[tidal spade]

Then why doesn't your code look like that code sample?

[humble rapids]

@tidal spade Query.equal() was the first Query i used, it not worked for me

[tidal spade]

Be clear and detailed. What did you do exactly and what does "not work" mean?

[humble rapids]

okay following the code sample at the bottom of the above url
i edited my code to this

        databaseId: Common.dataBasesId,
        collectionId: Common.collectionStoryTellerId,
        queries: [
          Query.orderDesc('\$createdAt'),
          Query.limit(500),
          Query.equal("userId", userModel.following),
        ],
      );```

and i keep getting this error `AppwriteException: general_query_invalid, Invalid query: Query on attribute has greater than 100 values: userId (400)`

[tidal spade]

Do you understand why?

[humble rapids]

i think i do,
the number items inside the userModel.following is more than 100 values

[tidal spade]

Exactly. So what can you do?

[humble rapids]

i really dont know what to do

[tidal spade]

What if you use Query.or()?

[tidal spade]

Also, what happens if you pass only 100 values instead of the full userModel.following?

[humble rapids]

it return the right values as expected

[humble rapids]

when i use the Query.or() i get this AppwriteException: general_query_invalid, Invalid query: Or queries require at least two queries (400)

i dont know what the second queries should be

[tidal spade]

Great. So you know how it works and that it does work. There's just the 100 values limitation you need to figure out which can be done using the or query

[tidal spade]

So you can only do Query.equal() with 100 values....but you have more than 100...how can you use or to get around this?

[humble rapids]

@tidal spade i cleary dont know what should be done beyound this point

[tidal spade]

Start with this:

          Query.or([
            Query.equal("userId", 100Followers),
          ]),
        ],

And you have another100Followers. What would you do?

[humble rapids]

i dont get to know if a follower on the follower list its 100 or above 100

[tidal spade]

Why not?

[humble rapids]

@tidal spade
this is still an issues

[tidal spade]

Why can't you tell if a list has more than 100 items?

[plucky crescent]

Using the length to determine the size of item in the array does not change the fact that the Query.equal() needs only 100 items in the array,

The more pressing issues right now @tidal spade is how do we get post of users irrespective if the array has fewer items less than 100 or above 100

You said I should study the doc via the link you supplied, I have done that sand still not getting the expected results

<@&634618551491100692> , I'm having issues trying to understand the use of Query.or() and Query.and()

I'm actually coming from a PHP SQL, maybe because of background I can't fully grasp the power of Query.or() and Query.and() in Appwrite concept (I thought it's the same everywhere)

Please I will be very grateful if anyone can actually point me the right thing to do

[sullen mist]

100 values is too much. What are you trying to achieve?

Do you really need to apply the query with 100 and get 500 elements?

[plucky crescent]

This is what I aim to achieve,
I have list of posts in my storyTeller Collection and it has a userID attributes of String and I want to check the userId with a string arrays of list of followers

So basically, if any users in follower array list make a post, retrieve all those documents that matches the users

[tidal spade]

Yes, so if you can only pass a list of 100, can't you break up your list so that it's multiple lists of 100 each?

[tidal spade]

And now you have to think about how to use the queries available to you to solve the problem

[tidal spade]

Please don't tag moderators just because you're struggling to figure out your problem

[tidal spade]

This isn't a php or SQL concept. It's a general programming concept

[grim burrow]

Also, please do not ping all moderators.

[plucky crescent]

Okay noted