B4J Question TreeView structure from Database

[Emanuel Straub]

Hi guys,

i need help by creating a TreeView structure from MySQL Table.
My database table has 3 columns:

1. id
2. name
3. parent_id

Now on client side i load the data via httpjob and parse it into json.

    Dim job As HttpJob
    job.Initialize("",Me)
    job.Username=Main.api_user
    job.Password = Main.api_pw
    job.Download($"${Main.server}/api/categories$)
    Wait For (job) jobDone(job As HttpJob)
    If job.Success Then
        Dim parser As JSONParser
        parser.Initialize(job.GetString)
        Dim root As List = parser.NextArray
        For Each colroot As Map In root
            Dim id As Int = colroot.Get("id")
            Dim name As String = colroot.Get("name")
            Dim parent_id As Int = colroot.Get("id")
            '??? here add the element in Treeview ???
        Next
    Else
        Log("No Server connection!")
    End If
    job.Release

Can anybody help me with this?

 

[DonManfred]

How to create a MySQL hierarchical recursive query?

I have a MySQL table which is as follows: id name parent_id 19 category1 0 20 category2 19 21 category3 20 22 category4 21 ... ... ... Now, I want to have a single MySQL query to which I sim...

stackoverflow.com

 

[Emanuel Straub]

Thank you DonManfred,

that solved it for me.