topic Activiti : Last completed task in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activiti-last-completed-task/m-p/157420#M111601 <HTML><HEAD></HEAD><BODY><SPAN>&lt;b&gt;Problem&lt;/b&gt;</SPAN><BR /><BR /><SPAN>I want to get the last task completed for the process instance. I am able to get the last completed human task, but not a Service task.</SPAN><BR /><BR /><SPAN>&lt;b&gt;What i have tried&lt;/b&gt;</SPAN><BR /><BR /><SPAN>I have written a SQL query, i am using MySQL, to find out what is last task that is completed. Here it goes :</SPAN><BR /><SPAN>&lt;blockcode&gt;</SPAN><BR /><SPAN>SELECT * FROM act_hi_taskinst </SPAN><BR /><SPAN>where PROC_INST_ID_= '1234' and END_TIME_ IS&nbsp; NOT NULL</SPAN><BR /><SPAN>order by END_TIME_ desc;</SPAN><BR /><SPAN>&lt;/blockcode&gt;</SPAN><BR /><BR /><SPAN>act_hi_taskinst is the table that gets updated as and when the process instance progresses.</SPAN><BR /><BR /><SPAN>The process flow goes something like this :</SPAN><BR /><BR /><SPAN>A human Task (Leave request) -&gt; Service task( Check availability of leave) -&gt; service task(Check feasibility) -&gt; A human task(Manager task)</SPAN><BR /><BR /><SPAN>When the task comes to Manager Task the last completed is Check feasibility, but its not reflecting in database.</SPAN><BR /><BR /><SPAN>Can you please help</SPAN><BR /><BR /><SPAN>Does activiti provide any such API to get the last completed service task? Can you suggest some SQL query to solve the problem.</SPAN></BODY></HTML> Thu, 03 Oct 2013 09:33:22 GMT madhusudanjoshi 2013-10-03T09:33:22Z Activiti : Last completed task https://connect.hyland.com/t5/alfresco-archive/activiti-last-completed-task/m-p/157420#M111601 &lt;b&gt;Problem&lt;/b&gt;I want to get the last task completed for the process instance. I am able to get the last completed human task, but not a Service task.&lt;b&gt;What i have tried&lt;/b&gt;I have written a SQL query, i am using MySQL, to find out what is last task that is completed. Here it Thu, 03 Oct 2013 09:33:22 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-last-completed-task/m-p/157420#M111601 madhusudanjoshi 2013-10-03T09:33:22Z Re: Activiti : Last completed task https://connect.hyland.com/t5/alfresco-archive/activiti-last-completed-task/m-p/157421#M111602 <HTML><HEAD></HEAD><BODY><SPAN>You can look in the historic activity table via the HistoryService. That gives an overview of the full execution path.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Thu, 03 Oct 2013 19:13:29 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-last-completed-task/m-p/157421#M111602 trademak 2013-10-03T19:13:29Z