Tree grid advanced widget

[NJ_10144761]

Hi,

I want to pull data from database and show on the Tree grid advanced widget. Can anyone please help me to create the service.

[Yedukrishnan]

Hi @NJ_10144761 ,

Please let me know your data storage-Stream/Valuestream/Datatable.

With regards 

Yedukrishnan

[NJ_10144761]

Stream, I am using a database thing

[Yedukrishnan · Accepted solution]

Hi @NJ_10144761 ,

Is it any external database or Thingworx database?

If external DB, you can write service with SQL commands -  SELECT * FROM table_name and service output as infotable.

If Thingworx DB, you will be storing the data in Stream/Datatable. 

In that case, you can write the service as follows.

SELECT * FROM stream WHERE entity_id = "Your stream name".

With regards

Yedukrishnan