ResolvedSelf HostedDatabases

[SOLVED] Not Equal Query

Dec 27, 2023, 21:01

View on Discord

Votes

Replies

Participants

Unknown

Messages

BloodThermicOriginal post

Rank 3: Container

May 26, 2023, 00:44

How do you query a collection for a not equals?

Summary

The user is asking about querying attributes in a collection. They mention that they are trying to exclude dates from a list collection. They are getting an error message indicating that the 'Title' attribute is not found in the collection. The user is asking for help on querying a collection for a not equals condition. Solution: It is clarified that collections do not have attributes. The error message is due to the user trying to query for an attribute that does not exist in the collection. They should modify their query to use an existing attribute.

BloodThermic

Rank 3: Container

May 26, 2023, 00:54

Plain text

        Query.notEqual("Title", ["dates"])
      ])```
I get this error
Error: Invalid queries: Query not valid: Attribute not found in schema: Title

Drake

Admin

May 26, 2023, 01:59

the error indicates there is no 'Title' attribute in collection 646587b51b84a01f2ba8

BloodThermic

Rank 3: Container

May 26, 2023, 02:00

But collections dont have attributes

Drake

Admin

May 26, 2023, 02:02

Oh wait...it also definitely doesn't have a Title

BloodThermic

Rank 3: Container

May 26, 2023, 02:02

When i remove attributes it still errors

Drake

Admin

May 26, 2023, 02:03

What do you mean?

BloodThermic

Rank 3: Container

May 26, 2023, 02:03

I am trying to exclude dates from list collections

Drake

Admin

May 26, 2023, 02:03

I still don't understand

BloodThermic

Rank 3: Container

May 26, 2023, 02:03

Like the date collections

Drake

Admin

May 26, 2023, 02:03

What are date collections?

BloodThermic

Rank 3: Container

May 26, 2023, 02:04

Its a collection for me to link dates that are in other collections

Drake

Admin

May 26, 2023, 02:05

Ok sure.... anyways, there is no Title in a Collection.

See for the attributes you can filter on https://appwrite.io/docs/server/databases?sdk=nodejs-default#databasesListCollections

BloodThermic

Rank 3: Container

May 29, 2023, 00:36

[SOLVED] Not Equal Query

Chola

Rank 2: Process

May 29, 2023, 07:30

Attributes that we can query are any attribute we have created? or is it only the appwrite system attributes like $createdAt

Drake

Admin

May 29, 2023, 07:31

Please create a new post in #channel

Chola

Rank 2: Process

May 29, 2023, 07:33

alright sorry, was just hoping for a quick response. BRB.
Hope you're well Steven

[SOLVED] Not Equal Query

Need support?_