Back
[SOLVED] Database error: "Invalid query: Attribute not found in schema:
iI have this query
TypeScript
const result = await databases.listDocuments(config.databaseId, config.collectionId, [
Query.select(['url', 'shortUrl, shortUrlFull']),
Query.offset(0),
Query.limit(1),
Query.equal("shortUrl", [shortUrl])
]);****
And from my understanding, this is requal to "SELECT url, shortUrl, shortUrlFull FROM SOME_COLLECTION WHERW shortUrl = SOME_URL"
I am getting an error while executing this that Attribute is not found in schema.
If I would remove url and shortUrlFull from this select it would most likelly work, but I need all of that.
Anything wrong in my queries here?
TL;DR
Title: [SOLVED] Database error: "Invalid query: Attribute not found in schema:;
Message: You have a typo in your select query - "shortUrl, shortUrlFull" should be "shortUrl", "shortUrlFull". Also, make sure "url" is not in quotes. Update your query to:
```
const result = await databases.listDocuments(config.databaseId, config.collectionId, [
Query.select(["url", "shortUrl", "shortUrlFull"]),
Query.offset(0),
Query.limit(1),
Query.equal("shortUrl", [shortUrl])
]);
```
This
well in your select query, it seems like url is in quotes, and shortUrl, shortUrlFull are in the same quotes
why not have two separate queries?
ah crap
I didn't see that typo
Ty
[SOLVED] Database error: "Invalid query: Attribute not found in schema:
