Read Action taken by user via Smart Object Client APIs


Badge

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


0 replies

Be the first to reply!

Reply