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
- Scheduled works locking the entire Maria...
I have a scheduled function and apparently that or something is locking the entire MariaDB database and Appwrite is giving MariaDB errors. This error persists e...
- Python Function not working
I am getting this issue as well. Doesnt look like there was a solution as you guys were not able to replicate. Below is my code as well as the error. I started...
- Migration Help
I have a small project which I have started using Appwrite cloud and now I want to self host Appwrite and migrate the data. I'm getting this error everytime I ...