11-Garnet

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.

Best answer by Yedukrishnan

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

14-Alexandrite

Hi @NJ_10144761 ,

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

With regards

Yedukrishnan

Author

11-Garnet

Stream, I am using a database thing

Answer

14-Alexandrite

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

Sign up