I have a query which returns the plant status and the stations in that plant status. How can I bind this in tree grid in order to show the hierarchy of plant and its respective stations?
How can we integrate the tree grid with sql queries?
My idea is to take the result of the query and put it in a datatable. After this, you can bind datatable with Tree grid as usual.
Hope it helps,
Hi @raluca_edu ,
I tried to fetch a data table like the attached screenshot, but its not giving me the expected result. In the image I am trying to fetch ORGANIZATION (parent) AND ITS RESPECTIVE PLANT(child). When I bind the getDatatableEntries, its not getting segregated according to the parent. Instead, it keeps repeating the whole data again as child.
Please tell me what I am missing.
Thanks in advance.
Please could you attach export of data table to try on my end?
Let me know also Thingworx version.
If you have found a solution to your issue, please feel free to post it here for the benefit of others on the community.