Hi All
I have a requirement where in I need to select process instances / folios in which action taken is not equal to "Cancelled".
I am using sourcecode.workflow.smartobject to read various process instance and their properties. Below is the code snippet.
string QueryStr = ConstructSQLQuery(K2ActivityName, K2ProcessName, IsDateRangeByStartDate,
soServer.ExecuteSQLQueryDataTable(SQLQuery);
public
string Query = "SELECT PI.* FROM Process_Instance PI inner join Activity_Instance AI on " + "PI.ProcessInstanceID = AI.ProcessInstanceID where ActivityName = " +"'" + K2ActivityName + "' and ProcessName = " +"'" + K2ProcessName + "' and PI.Status ='" + K2ProcessStatus.Completed + "' ";
return Query;
string ConstructSQLQuery(string K2ActivityName, string K2ProcessName, bool IsDateRangeByStartDate,string beginDateTime, string endDateTime){
Question: Does any one know which k2 workflow smart object can be used to read the name of last "Action" taken by user from the Actions dropdown list. In this case I want to filter process for Action="Cancelled"
Thanks