The API only allows access to running instances. Once an instance has been completed, it gets logged to the log database and the only way to get access is through the reporting SmartObjects or SQL queries. 

Side question, what is the reason for opening a completed instance? 

I'm working on an application that brings a user through a series of questions with the purpose of providing an answer at the end.  I'm using K2 as the decision engine, it is determining what question(s) to ask after each set of questions is answered and finally providing the "answer" at the end of the process.  To help with this, I'm using the PageFlow ideas found in the blackmarket project "ASPX Controls for k2 blackpearl" to move a user through the decision making process.

At the end of the process, I was trying to get the data fields in the process to display the conclusion, however, I couldn't get the process instance to load.  I can just get the values from a SmartObject, so it'll still work out.

Thanks a lot for the help,

Greg

Interesting use of K2 .

Good luck with your application.

If you have this working I would appreciate a nudge in the right direction. I'm in a similar situation where I need to read fields from a finished process but I am not sure how to go about using the SmartObjects and I can't find the data in SQL.

Hi,

you can use the below code to fetch the completed instance. smartobject name is the input parameter for this method. you can find this smartobject name for your process in k2 smartobject tester( go to workflow Reports>Workflow solutions> open ur process name and right click view xml)

<smartobjectroot name="Rpt_Process name" >

for exmaple: from  the above sample XML: Rpt_Procees Name

 is smartobject name

Code to fetch completed process instance:

public DataSet GetCompletedTask(string strSmartObjectName)

        {

            DataSet ds = new DataSet();

            DataTable dt = new DataTable();

            DataRow dr;

            SourceCode.SmartObjects.Client.SmartObjectClientServer serverName = new SourceCode.SmartObjects.Client.SmartObjectClientServer();

            SourceCode.Hosting.Client.BaseAPI.SCConnectionStringBuilder connectionString = new SourceCode.Hosting.Client.BaseAPI.SCConnectionStringBuilder();

            // build a connection string

            connectionString.Authenticate = true;

            connectionString.Host = "server name";

            connectionString.Integrated = true;

            connectionString.IsPrimaryLogin = true;

            connectionString.Port = 5555;

            // open a K2 Server connection

            serverName.CreateConnection();

            serverName.Connection.Open(connectionString.ToString());

            try

            {

                SourceCode.SmartObjects.Client.SmartObject smartObject = serverName.GetSmartObject(strSmartObjectName);

                smartObject.MethodToExecute = "ListProcessInstances";

                smartObject.PropertiesO"Status"].Value = "Completed";

                // call the method

                SourceCode.SmartObjects.Client.SmartObjectList oSmOList = serverName.ExecuteList(smartObject);

                if (oSmOList.SmartObjectsList.Count > 0)

                {

                    //To Create dynamic datacolumn

                    foreach (SourceCode.SmartObjects.Client.SmartObject oSmO in oSmOList.SmartObjectsList)

                    {

                        foreach (SourceCode.SmartObjects.Client.SmartProperty oProp in oSmO.Properties)

                        {

                            DataColumn dc = new DataColumn();

                            dc.ColumnName = oProp.Name;

                            dt.Columns.Add(dc);

                        }

                        break;

                    }

                    // iterate each smartobject in the collection

                    foreach (SourceCode.SmartObjects.Client.SmartObject oSmO in oSmOList.SmartObjectsList)

                    {

                        dr = dt.NewRow();

                        foreach (SourceCode.SmartObjects.Client.SmartProperty oProp in oSmO.Properties)

                        {

                            drtoProp.Name] = oProp.Value;

                        }

                        dt.Rows.Add(dr);

                    }

                    if (dt.Rows.Count >= 1)

                        ds.Tables.Add(dt);

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

            finally

            {

                // close the connection

                serverName.Connection.Close();

            }

            return ds;

        }