"Payload has transformed the way our clients manage content. It's an indispensable tool for any modern agency."
Microsoft chose Payload to tell the world about AI.
Querying nested-docs
What is the recommended way of querying nested-docs when you know the path?
Given the following paths:
/parent-page
/parent-page/child-page
/parent-page/child-page/grandchild-page/api/pages?where[breadcrumbs.url][equals]=/parent-page/child-page
This query returns both the child-page document, and the grandchild-page document ...
I'm having trouble figuring out how to retrieve only the page that matches this path exactly. I am temporarily using a hidden auto-generated field, that takes the last breadcrumb and stores it's
urlinto a
pathfield at the document root ... so I can query
where[path][equals]=/parent-page/child-pagebut this seems awkward, and I'm assuming there's a proper way to query nested-docs?
That url probably fails because the forward slashes in your
wherequery are not encoded, which would look like this:
/api/pages?where[breadcrumbs.url][equals]=%2Fparent-page%2Fchild-pageBut this may match on multiple docs instead of just one, because the breadcrumb may appear across more than one document, especially within the same tree.
You may want to query by
slugthen find the document whose
lastbreadcrumb matches your url
thanks - I think that helped. I just added the slug to the query and that seems to have resolved it ...
I now have something like this ...
?where[breadcrumbs.url][equals]=/new-page/child-page/grandchild-page&where[slug][equals]=grandchild-pageThe URL does get encoded by the browser before sending, I'm just showing the decoded version for readability.
Star
Discord
online
Get dedicated engineering support directly from the Payload team.