I have a collection that is related to the user account so it has a userId attribute that I use to store the user's ID. A user should only have one record for this collection but I can't seem to make this userId attribute the primary key for the collection. It always creates a document ID that I need to reference. I know that I can always get the document first by searching the userId - and then use the document ID from there to update the values of the document but I was hoping there would be a better way to do this.
What you can do is to set the document ID as the user ID and then you have the primary key uses the user ID.
Oh you mean when I create the document, instead of using ID.unique(), I'll use the user ID instead.. I don't know why I didn't think of that. Thank you!
Does that solves your issue?
Yes it does. It was my bad for not thinking of such a simple solution.
Great! 😁
[SOLVED] How to update a document without knowing the document ID?
Recommended threads
- AppwriteException: Invalid query: Query ...
```js console.log(typeof interaction.user.id) console.log(interaction.user.id) const user_check = await TablesDB.listRows({ databaseId: "db", ...
- general_unauthorized_scope
localhost oauth not working. general_unauthorized_scope error showing. { "message": "User (role: guests) missing scopes ([\"account\"])", "code": 401, ...
- I recently switched to TablesDb. When li...
olddb.list_documents( queries =[ Query.order_desc("timestamp"), Query.equal("isPosted",[False]) ] ) Above works fine and reruns documents But below don't return...