I'm not sure if this was already asked here, I cannot find the same issue I'm having. So here it is.
Currently, I have two collections with relationship Entry <-- Category, when I'm trying to fetch the data of the Entry the Category data I needed returns to me is null.
TypeScript
export async function getEntries() {
const { documents } = await databases.listDocuments(
process.env.NEXT_PUBLIC_APPWRITE_JOURNAL_DATABASE_ID as string,
process.env.NEXT_PUBLIC_APPWRITE_JOURNAL_COLLECTION_ID_ENTRY as string
);
return {
entries: documents.map(mapDocumentToEntries),
};
}
I'm thinking maybe, I need to use the Collection_ID for the Category collection. But the API only accepts one Collection_ID
TL;DR
Issue: Relationship data returning null when fetching entries with corresponding categories data.
Solution: Ensure to set up the relationship between `Entry` and `Category` as "many to one" to have the categories data populated in entries. Additionally, when fetching entries, use the correct `Collection_ID` for the Category collection to get the desired data.What type of relationship did you create; 1-way or 2-way?
One way. and set it to "many to one"
If it's one way from Category to Entries, then entries won't have categories data, but categories will have entries data
this how I set it up. The Entries/Journal have the attribute that I got from Category.
found the issue. 🤦
What was it? :)