topic Activiti : Last completed task in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activiti-last-completed-task/m-p/157311#M111504 <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 /><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>&lt;b&gt;Can you please help&lt;/b&gt;</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:26:33 GMT madhusudanjoshi 2013-10-03T09:26:33Z Activiti : Last completed task https://connect.hyland.com/t5/alfresco-archive/activiti-last-completed-task/m-p/157311#M111504 &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:26:33 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-last-completed-task/m-p/157311#M111504 madhusudanjoshi 2013-10-03T09:26:33Z Re: Activiti : Last completed task https://connect.hyland.com/t5/alfresco-archive/activiti-last-completed-task/m-p/157312#M111505 <HTML><HEAD></HEAD><BODY><SPAN>The data will not be stored in act_hi_taskinst, but in ACT_HI_ACTINST . act_hi_taskinst is only for user tasks (because queries there are way more common)</SPAN></BODY></HTML> Fri, 04 Oct 2013 08:26:58 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-last-completed-task/m-p/157312#M111505 jbarrez 2013-10-04T08:26:58Z Re: Activiti : Last completed task https://connect.hyland.com/t5/alfresco-archive/activiti-last-completed-task/m-p/157313#M111506 <HTML><HEAD></HEAD><BODY><SPAN>Thanks jbarrez!! <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></SPAN><BR /><BR /><BR /><A href="http://become-the-alpha-male.com/blog/what-are-the-best-testosterone-boosters/" rel="nofollow noopener noreferrer"><SPAN style="color: #FDFDFF; text-decoration: underline;">testosterone boosters</SPAN></A></BODY></HTML> Sat, 05 Oct 2013 12:35:14 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-last-completed-task/m-p/157313#M111506 nicholascurren 2013-10-05T12:35:14Z