Query on relationships
Hi, I am trying to select get info from a relationship. When I just list documents i get this output:
{
"total": 1,
"documents": [
{
"bib": 1,
"name": "valou",
"$id": "6735dffb0020d0a5fbb3",
"$createdAt": "2024-11-14T11:33:16.056+00:00",
"$updatedAt": "2024-11-14T11:33:16.056+00:00",
"$permissions": [],
"times": [
{
"time": "2024-11-14T14:21:23.345+00:00",
"$id": "6735f95f000be8949b18",
"$createdAt": "2024-11-14T13:21:35.942+00:00",
"$updatedAt": "2024-11-14T13:21:35.942+00:00",
"$permissions": [],
"location": {
"name": "location_name",
"tns_name": "tns2",
"$id": "6735f9260034476bfcb7",
"$createdAt": "2024-11-14T13:20:39.468+00:00",
"$updatedAt": "2024-11-14T13:20:39.468+00:00",
"$permissions": [],
"$databaseId": "672fbf550001be0825cf",
"$collectionId": "6735df73000d17f21013"
},
"$databaseId": "672fbf550001be0825cf",
"$collectionId": "6735e0210021135b8061"
}
],
"$databaseId": "672fbf550001be0825cf",
"$collectionId": "6735dfcb00216f8f8aac"
}
]
}
However I want to filter out lots of the data and only show the name, bib and the time within the times object. How do i do this?
I have tried: Query.select(["bib", "name", "times"]) and Query.select(["bib", "name", "times.time"])
Relationships are in beta and queries are not officially supported on them.
Too bad but thanks for the quick answer
Is there perhaps an easy workaround that still allows me to run queries in the backend
I think right now, at this point the best thing to do is to manually create the relationships yourself when fetching the data. So instead of using the relationship attribute setup a foreign key attribute, then fetch the parent item, once you've got that fetch the child.
