How to query the completed workflow instance

Off the top of my head you could query the Activity Instance Audit SmartObject and filter by Process Name and User name?

Hi Ruciffa,

I assume you want to do this in code, so here's how you'd do it.

First of all, make a connection to the SmartObject server using port 5555 (Google SCConnectionStringBuilder for examples). Open this connection, and then you need to load up the SmartObject, filter it and execute the method. Here's some code (I haven't compiled this so it may not work):

            var smartObjectClientServer = new SmartObjectClientServer();

            var cb = new SCConnectionStringBuilder
            {
                // Set up your connection values
            };

            using (BaseAPIConnection conn = smartObjectClientServer.CreateConnection())
            {
                conn.Open(cb.ToString());
               
                var dataAuditSmartObjectDefinition = smartObjectClientServer.GetSmartObject("Activity_Instance_Audit");
                dataAuditSmartObjectDefinition.MethodToExecute = "List";
                dataAuditSmartObjectDefinition.Properties["Process_Name"].Value = "Your process name";
                dataAuditSmartObjectDefinition.Properties["User_Name"].Value = "Your username";
                var results = smartObjectClientServer.ExecuteList(dataAuditSmartObjectDefinition);
            }

the results variable wqill now contain a list of SmartObjects. Loop through these and you can read the values like a dictionary, i.e. smartObject.Properties["User_Name"].Value etc

Hope that helps?

hello, another question

to getting some datafields in the same workflow instance, i use the processID i queried in the code above to open the process in K2 Server, but failed.  it seems it's different to get datafield between the active instance and completed instance, it's said this process is not found, i queried the process id from :

processInstanceId = oSmO.Properties["ProcessInstanceID"].Value.ToString();

and use this code to read data field

Connection conn = new Connection();

            //create connection string
            SourceCode.Hosting.Client.BaseAPI.SCConnectionStringBuilder builder = new SourceCode.Hosting.Client.BaseAPI.SCConnectionStringBuilder();

            builder.Host = "localhost";
            builder.Port = 5252;
            builder.SecurityLabelName = "K2";
            builder.Authenticate = true;
            builder.IsPrimaryLogin = true;
            builder.Integrated = true;

            // Connect to Workflow Server
            conn.Open("localhost", builder.ConnectionString);

ProcessInstance pi = conn.OpenProcessInstance(Int32.Parse(processInstanceId));

                    dr["Stage"] = pi.DataFields["DDLStage"].Value.ToString();
                    dr["Testing Program Name"] = pi.DataFields["TBTestingProgramName"].Value.ToString();

How to query the data field of the same instance in this scenario ?

Hi,

Keep in mind that the reporting SmartObjects will return data on Active and Completed Process Instances. Your code above only makes use of the Workflow.Client API and therefore will only work if the process is still active. This code will not work for process instances which were completed. Also note that the OpenProcessInstance method requires the executing user to be an Admin on the Process definition.

A better approach here would be to use the Reporting SmartObjects to get the Data Field values. There is a SmartObject called Activity_Data which you can use for this purpose. It has a Process Instance ID field which you can use to filter the results. This will work for active and completed instances. The only prerequisite is that the executing user needs to have View or View Participate rights to view the results. (If you are using View Participate, the executing user must have been a destination or the originator of the process)

I hope this helps!