I have this data const data = [ { name: "Car", id: "19", count: "20", depth: "1", children: [ { name: "Wheel", id: "22", count: "3", depth: "2", children: [ { name: "Engine", id: "101", count: "1", depth: "3", children:…
hello i have table profile that has many attributs, and the profile has on parent but the parent can have a parent etc.. I want to get all the list of the attributs(even the attributs of the parents) i wrote…
I'm trying to select this hierarchical JSON as a table in PostgreSQL The JSON script: '{"NODES":[{"DESC_D":"fam","SEQ":"1","ID":"2304500","NODES":[{"DESC_D":"test 1","SEQ":"2.1","ID":"5214","NODES":[{"DESC_D":"test 1.1","SEQ":"3.1","ID":"999"}]},{"DESC_D":"test 2","SEQ":"2.2","ID":"74542"}]}]}' The output I'm trying to get (click this link) This is a solution a friend wrote. It does the required but…
I need to make sure we have support to create a hierarchy table based on a "father/son" table. Example: F S a b b c b d b e e f e g b m z n m k Expected…
This is my database on mysql and I need extract concatenating all the parents and all children. id | name | parent_id | has_children 100017 | Roupas Femininas | 0 | 1 100018 | Meias | 100017 | 1 100419…