Indirect relational data on Appwrite adapter in Refine
I currently want to add an indirect relation to a resource in Refine. I have two database and they have their own collections. But in each database there are some collections that they have indirect relationship. For example in Catalog database I have Product collection. And on the Commerce database I have OrderItems collection. OrderItems collection should have the ProductId but since Appwrite doesn't let us have a relationship or does not return related data on the query result, we need to find a way to get those indirect related data to the Refine table.
Does anyone know how t accomplish this?
Does anyone know how t accomplish this?
