I am trying to create a blog posting website in appwrite, I am having issue in that

I am trying to create a blog website, in that I am having categories, categories is a different collection and blogs having different collection, I want to get blogs on the catgories basis , as I am trying to create a filter this is collection for categories and blogs

I am getting this while I call posts [ { "title": "post 1", "content": "asdf dsfasd fsdf sfsdaf sdfsa dsfsad fsdafs dafsadf sf sdfasfsa fsdf safas", "$id": "676d7ebe0018ac3cd99f", "$createdAt": "2024-12-26T16:05:18.820+00:00", "$updatedAt": "2024-12-26T16:05:18.820+00:00", "$permissions": [], "cat": [ { "name": "bootstrap", "$id": "676d7d990037e790e966", "$createdAt": "2024-12-26T16:00:26.292+00:00", "$updatedAt": "2024-12-26T16:00:26.292+00:00", "$permissions": [], "$databaseId": "676d06010009cae63ccc", "$collectionId": "676d7d6b001146714f74" } ], "$databaseId": "676d06010009cae63ccc", "$collectionId": "676d7cfb0023161fc848" },

]

now, How I can filter data on the basis of categories

just querry categories...$

like get the document which represents the categorie and you get all the related blogs? @Ashish