Skip to main content
wsuen1-Visitor
1-Visitor
January 3, 2018
Solved

How to handle multiple result sets

  • January 3, 2018
  • 2 replies
  • 1923 views

Hi There,

I have a service that executes a Store Procedure that returns 2 results sets. I cannot edit the SP because the client doesn't want to.

How do I handle multiple result sets in Thingworx?

Thank you in advance for your help.

Best answer by wsuen

Nvm. I created another service in js to call the service that executes the SP. And used a datashape that have multiple info tables. Then in the js service got a specific table and its row and column

2 replies

jjohnson-211-Visitor
1-Visitor
January 3, 2018

Hello Wendy,

Have you tried to run the service against the store procedure? Is it coming back as one large InfoTable or something different?

wsuen1-VisitorAuthorAnswer
1-Visitor
January 3, 2018

Nvm. I created another service in js to call the service that executes the SP. And used a datashape that have multiple info tables. Then in the js service got a specific table and its row and column

Terms & ConditionsAccessibility statement