4 Replies Latest reply on Apr 27, 2017 6:14 AM by nkhose RSS
    sdaram-2 Newbie

    How to Execute Stored Procedure Which Has Two Result Set in Thinworx

    Hi All,

     

    I have Stored Procedure that will return Two Result Sets . I am Trying to Execute This Stored Procedure from Thingworx Service But unable to get results.

     

    While I am running stored Procedure in MSSQL Database i am able to get values in 2 result set but when i run Same Procedure in Thingworx Service nothing is coming.

     

     

     

    Please let me know How to resolve this Issues. Looking for positive response.

     

    Regards

    Spandhana

      • Re: How to Execute Stored Procedure Which Has Two Result Set in Thinworx
        sdaram-2 Newbie

        In SQL Server When I execute stored procedure it is getting result in 2 result set

         

        In My scenario the above values i have to display in Datagrid in Thingworx Composer.

         

        Steps I have done.

        1)I have Created a Datashape Which have all columns which we are getting from Stored proecure.

        like PLID,PPId,UserId,PathId(resultset1 columns) ..................................................TargetProperty,PropertyValueType,PropertyValue....................................etc(ResultSet2 columns) in single datashape.

         

        2) I have Created a Service to call my stored procedure.  by mapping my Datashape  "KPI_Main_Grid_DataShape" to service.

        The Stored proecure Expecting some input parameters i am passing default values to execute stored proecure.

         

         

         

         

        Note:- Here my issue is i am unable to get values from stored procedure when i call from thingworx service.

         

        I Hope everyone understand my scenario looking for help to resolve my issues.

         

        Thanks & regards

        Spandhana Daram