Skip to main content
S
svisveswaraiya_2859881-Visitor
1-Visitor
February 12, 2020
Question

tree grid using sql data

  • February 12, 2020
  • 2 replies
  • 1950 views

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.

2 replies

R
raluca_edu17-Peridot
17-Peridot
February 13, 2020

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

S
svisveswaraiya_2859881-VisitorAuthor
1-Visitor
February 18, 2020

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.

R
raluca_edu17-Peridot
17-Peridot
February 27, 2020

Hi,

 

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

Let me know also Thingworx version. 

 

Thanks,

Raluca Edu

S
slangleyCommunity Manager
Community Manager
March 5, 2020

Hi @svisveswaraiya_285988.

 

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

Terms & ConditionsCookie settingsAccessibility statement