Solved: Tree grid advanced widget - PTC Community

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.

ACCEPTED SOLUTION

Accepted Solutions

(To:NJ_10144761)

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 solution in original post

3 REPLIES 3

(To:NJ_10144761)

Hi @NJ_10144761 ,

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

With regards

Yedukrishnan

(To:Yedukrishnan)

Stream, I am using a database thing

(To:NJ_10144761)

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

Top Tags