ValouOriginal post
Web Developer
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"])
Summary
Developers are advised to manually create relationships when fetching data rather than relying on relationship attributes. Although queries are not officially supported on relationships and are currently in beta, a workaround is suggested to fetch parent and child items separately. To filter and display specific data from a relationship like name, bib, and time, developers should use `Query.select(["name", "bib", "times.time"])` instead of `Query.select(["bib", "name", "times"])` which will still display unnecessary data.