Skip to main content
V
vcavic1-Visitor
1-Visitor
April 1, 2021
Solved

Join for two different database tables Windchill and Postgresql in Thingworx

  • April 1, 2021
  • 2 replies
  • 1787 views

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

    Best answer by zyuan1

    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.

    2 replies

    Z
    zyuan15-Regular MemberAnswer
    5-Regular Member
    April 2, 2021

    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.

    V
    vcavic1-VisitorAuthor
    1-Visitor
    April 6, 2021

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

    Z
    zyuan15-Regular Member
    5-Regular Member
    April 8, 2021

    It's internal training and not accessible.

     

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

    S
    slangleyCommunity Manager
    Community Manager
    April 19, 2021

    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

    Terms & ConditionsCookie settingsAccessibility statement