So I know relationships are in beta, but we are making a datagrid and I setup relationships because it made the data processing a bit more efficient for pulling things to display and such. We're trying to create a datagrid that displays members. Easy, cause we have a members collection. After that, we have a search, which also works great thanks to 1.5's search implementation.
The real issue is, we have a councils filter, because each member can be on councils. So we have that relationship, but we want to be able to filter by any council ID.
Do I need to make an array of ID's as a separate attribute with an event to update it, or can I filter by the relationship $id attributes?
It says I can't, but I'm curious if there's a way around it that's known or something
realistically I'd have to basically either make a second column that gets auto updated or maybe search by councilId and then display that councils members but I can't search in that relationship either can I?
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", ...
- Files access permissions
Am I right in understanding that file access permissions have been disabled (or broken again), and that shared access can now only be organized via tokens? Or i...
- functions custom domain issues in self h...
I’m running self-hosted Appwrite (Docker) behind Traefik with Cloudflare proxy (Full/Strict). Main domain works: https://app.printa4.in Function subdomains fa...