cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

tree grid using sql data

Highlighted

tree grid using sql data

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.

4 REPLIES 4
Highlighted

Re: tree grid using sql data

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

Re: tree grid using sql data

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.

Highlighted

Re: tree grid using sql data

Hi,

 

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

Let me know also Thingworx version. 

 

Thanks,

Raluca Edu

Highlighted

Re: tree grid using sql data

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

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!