tree grid using sql data

[svisveswaraiya]

Hi,

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?

Thanks,

svisveswaraiya.

[raluca_edu]

Hi,

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,

Raluca Edu

[svisveswaraiya]

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.

[raluca_edu]

Hi,

Please could you attach export of data table to try on my end?

Let me know also Thingworx version. 

Thanks,

Raluca Edu

[slangley]

Hi @svisveswaraiya.

If you have found a solution to your issue, please feel free to post it here for the benefit of others on the community.

Regards.

--Sharon