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
- In operator
can we have in operator or if you can suggest any workaround
- Having problems with Appwrite API keyAny...
Having problems with Auth as a result of the API key Anyone to help asap?
- Custom domain verification failing
Im having trouble adding custom domain to my project with the domain verification failing within my project but in organization view its verified