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

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

Join for two different database tables Windchill and Postgresql in Thingworx

vcavic
13-Aquamarine

Join for two different database tables Windchill and Postgresql in Thingworx

Hi,

is it possible that we  merge  two different database tables Windchill and Postgresql  with same key ID and display in Thingworx Mashup Grid Advanced?

 

BR

Vladimir

1 ACCEPTED SOLUTION

Accepted Solutions

Sure, we have join service in snippet, and if you can get infotable result from TWX and windchill, surely you can get a joined result.

View solution in original post

5 REPLIES 5

Sure, we have join service in snippet, and if you can get infotable result from TWX and windchill, surely you can get a joined result.

vcavic
13-Aquamarine
(To:zyuan1)

@zyuan1 Any Tutorial? I can get infotable result from TWX(Database ThingTemplate) and windchill(oDataConnector). 

It's internal training and not accessible.

 

But you can start by testing the APIs in Resource: infoTableFunctions 

And also the filters,  it has leftJoin, right join, between, etc.

slangley
23-Emerald II
(To:vcavic)

Hi @vcavic

 

If you feel your question has been answered, please make the appropriate response as the Accepted Solution for he benefit of others with the same question.

 

Regards.

 

--Sharon

Top Tags