I don't get the facet_return_query to work. What a...
# community-helpc
Christopher Lindblom
01/12/2025, 3:28 PMI don't get the facet_return_query to work. What are the requirements, object itself be indexed/facet? Do the fields that I want to return have to be indexed/facet? Or just the field that I actually facet by? I tired to search the repo on github without any luck so I started to wonder if it was removed? I'm using 27.1. In github I only found a cost and some tests but no impl reference to the argument name or the const variable (but I also had my kids running around so focus was not 100%).
Christopher Lindblom
01/12/2025, 3:28 PMThe problem I have with it is that I don't get any parent field, no matter what I do.
Christopher Lindblom
01/12/2025, 3:30 PMThe facet value I'm using was city.name and I wanted to include city.slug. The collections is pizzerias. So city is a field on the pizzeria document.
k
Kishore Nallan
01/12/2025, 3:54 PMThe parameter is called
facet_return_parentKishore Nallan
01/12/2025, 3:54 PMPlease also try with the latest v28 rc build. I remember us fixing an issue we found on v27.1
c
Christopher Lindblom
01/12/2025, 3:55 PMSorry. Im on the phone, wrote the wrong thing. I copied the parameter from docs. OK, will do 👍
Christopher Lindblom
01/12/2025, 4:06 PMtried it now using rc33, same result,
My query is a multi search looking like this:
{
searches: [
{
q: "*",
collection: "pizzerias",
facet_by: "city.name",
facet_return_parent: "city.slug",
per_page: 1,
max_facet_values: 9999,
facet_strategy: "exhaustive",
},
],
}
And i also include a screenshot of a document in dashboard, the whole doc is way too big to add.
Christopher Lindblom
01/12/2025, 4:23 PMIs there something obviously wrong with the way I query? And what are the requirements when it comes to indexing to get the parent field to be included in the facet response?
k
Kishore Nallan
01/12/2025, 4:42 PMDid you try:
Copy code
"facet_return_parent": "city.name",❤️ 1
💫 1
⭐ 1
Kishore Nallan
01/12/2025, 4:43 PMIf that does not work, please produce a set of curl commands that can reproduce the issue, like this: https://gist.github.com/jasonbosco/7c3432713216c378472f13e72246f46b
c
Christopher Lindblom
01/12/2025, 5:21 PMhum,.. city.name does work. But i want city.slug? The facet is on name, but i need the slug in the ui..
Christopher Lindblom
01/12/2025, 5:46 PMi misunderstood everything. It gets the whole parent doc if it matches the value. When i put the same i get the full { id: 19, name: 'Jönköping', slug: 'jonkoping' }
Christopher Lindblom
01/12/2025, 5:46 PMthis is awesome.
Christopher Lindblom
01/12/2025, 5:46 PMyou are awesome
Christopher Lindblom
01/12/2025, 5:47 PMmessage has been deleted
k
Kishore Nallan
01/13/2025, 5:05 AMGlad to hear, thank you.