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

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

How to handle multiple result sets

wsuen
6-Contributor

How to handle multiple result sets

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.

1 ACCEPTED SOLUTION

Accepted Solutions
wsuen
6-Contributor
(To: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

View solution in original post

2 REPLIES 2

Hello Wendy,

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

wsuen
6-Contributor
(To: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

Top Tags