Skip to main content
NJ_1014476111-Garnet
11-Garnet
Dec 21, 2023 9:37 AM UTC
Solved

Tree grid advanced widget

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.

YedukrishnanAnswer
14-Alexandrite
Dec 21, 2023 10:33 AM UTC

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

View in thread

3 replies

Yedukrishnan14-Alexandrite
14-Alexandrite
Dec 21, 2023 9:43 AM UTC

Hi @NJ_10144761 ,

 

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

 

With regards 

Yedukrishnan

Translate
NJ_1014476111-GarnetAuthor
11-Garnet
Dec 21, 2023 9:58 AM UTC

Stream, I am using a database thing

NJ_10144761_0-1703152733973.png

 

Translate
Yedukrishnan14-AlexandriteAnswer
14-Alexandrite
Dec 21, 2023 10:33 AM UTC

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

Translate
Terms & ConditionsAccessibility statement