Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X
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.
Solved! Go to Solution.
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
Hello Wendy,
Have you tried to run the service against the store procedure? Is it coming back as one large InfoTable or something different?
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