Skip to content
Back
ResolvedSelf HostedWeb

[SOLVED] Queries not working

View on Discord

Votes

1

Replies

24

Participants

Unknown

Messages

25

WildAnimalOriginal post

Rank 2: Process

I noticed that official example using Query at the front end like this:

JavaScript
import { Client, Databases, Query } from "appwrite"

But I use it in node-appwrite at the server side like this:

TypeScript
import { Client, Databases, Query } from "node-appwrite"

Is it wrong about this? Is it can not work in node-appwrite sdk.

Drake

Admin

did you run the migrate command after upgrading?

WildAnimal

Rank 2: Process

yes, I have run the migrate command. 😫

Drake

Admin

It works for me 🧐

Drake

Admin

What results do you get if you filter for disabled = true?

WildAnimal

Rank 2: Process

It still lists all documents, same as never change the conditions.
All conditions are not working at all.
But the queries work well in local development env.

WildAnimal

Rank 2: Process

TypeScript
  const client = new Client().setEndpoint(appwrite_endpoint).setProject(appwrite_project).setKey(appwrite_key);
  const databases = new Databases(client);
  const appwrite_conditions = [
    Query.select(['$id', 'messageTitle']),
    Query.equal('disabled', false),
    Query.limit(10),
    Query.orderDesc('created'),
  ];


  const purpose = (context.query.purpose as string) ?? '';
  if (purpose) {
    appwrite_conditions.push(Query.equal('systemPurposeId', purpose));
  }


  return databases.listDocuments(appwrite_databaseId, appwrite_collectionId, appwrite_conditions).then(
    (res: any) => {
      return {
        props: {
          conversations: res.documents,
          purpose: purpose,
        },
      };
    },
    (err) => {
      return {
        props: {
          error: {
            message: err.message ?? 'Unknown error.',
            status: err.code ?? 500,
          },
        },
      };
    },
  );
Drake

Admin

You have a local Appwrite instance and another Appwrite instance?

WildAnimal

Rank 2: Process

local for dev another at remote for prod

Drake

Admin

You definitely need to make sure you're connecting to the right instance...and the schemas match

WildAnimal

Rank 2: Process

How to view the logs of get documents with query to confirm the request url and test it?

Drake

Admin

Maybe traefik logs if it's enabled

Bouahaza

Rank 4: Virtual Machine

To order you need to set "$createdAt"

Bouahaza

Rank 4: Virtual Machine

With $

WildAnimal

Rank 2: Process

I have list all containers with command: docker ps
And got the container id then checked the logs of traefik:2.7 image.
There are only tow lines contents:

Bash
time="2023-05-27T02:20:01Z" level=info msg="Configuration loaded from flags."
time="2023-05-27T02:20:04Z" level=error msg="the router appwrite_realtime_wss@docker uses a non-existent resolver: dns"
Bouahaza

Rank 4: Virtual Machine

accesslog is disable by default

WildAnimal

Rank 2: Process

You are right. But I defined a customized attribute named created.

Bouahaza

Rank 4: Virtual Machine

Ok

WildAnimal

Rank 2: Process

Thanks.

Chola

Rank 2: Process

I too have an issue with querying a collection using Query.equals('attribute','123') , i get nothing in return no matter what i do.
I'm using cloud Appwrite so i cannot update it

Drake

Admin

Feel free to create a new post in #channel

WildAnimal

Rank 2: Process

This post has been resolved. Earlier, I had changed the node-appwrite api request method from axios to fetch and losted the query parameter. Now, I have resumed and it is work well. It's all my fault.

safwan

[SOLVED] Queries not working

Join the discussion

Reply to this thread by joining our Discord.

Reply on Discord

Need support?_

Join DiscordGet premium support