I Want to Do I have two types of Nodes, Categories and Products - and Categories can have related subcategories (which are themselves Categories). I’m trying to query root Categories (categories without any parent category), each with a list of communities representing all the communities related t…

Recurse won’t work for that case. Try to use normalize { q(func: type(Category)) @filter(NOT has(<~Subcategory>)) { Subcategory @normalize { Communities: Communities } } } What are(I mean the type) Communities? a string? objects? How many sub cats it can have?

Communities are nodes as well. Normalize as above will return a category object with a normalized subcategory field. I’m looking to return a community field with a list of any community related to any subcategory - if that makes sense. I’d like to traverse the graph until all subcategories (and su…

How many sub cats it may have? Do you mind sharing the desired result? I think I know how to. But a mock of the desired result would be great.

How many sub cats it may have? Unlimited Desired result: { "data": { "query": [ { "uid": "0x9df7", "Category.name": "Example Category", "products": [ {uid: "0xxdf7", product_name: "Example Product"}, {uid: "0xfdf7", product_name: "Examp…

The products are under Communities?

Sorry, I meant to write Category - not Communities. Categories have many products, and products can have many categories.

Thinking… Can you share the recurse query you have tried? The way I have thought would work for a single root category. So you would do a query for each category.

Actually, I think I was able to figure it out with your help :slight_smile: { query(func: type(Category)) @filter(NOT has(Category.categories)) @recurse { uid name: Category.name products: Category.products product_name: Product.name } }

The only thing is I had to add the parent categories to all child products to get this to work :confused: Do you know of a way where this isn’t needed?

Nice, I was about to recommend this { query(func: type(Category)) @filter(NOT has(Category.categories)) @recurse { uid name: Category.name products: Category.products @normalize product_name: Product.name } } To check if it work.

Query all of a given category (with sub-categories)

Users Dgraph

jamilabreu January 26, 2021, 1:28am 16

@MichelDiz I think what I need is

_foreach

1 Like

Topic		Replies	Views
Returning Nth degree related nodes Dgraph kind:question , dgraph	6	880	January 30, 2021
Recursive query with aggregation Dgraph	2	1065	April 27, 2018
Recurse after filter Dgraph	10	1428	November 2, 2018
Need to get details from hierarchy level data GraphQL	4	62	December 6, 2024
Recursive query with dgraph Dgraph	16	4660	November 20, 2020

Query all of a given category (with sub-categories)

Related topics