topic How do you query for completed tasks in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-do-you-query-for-completed-tasks/m-p/144749#M101210 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to query for completed tasks and I can't find a way to do it through the TaskQueryService and I do not know the database tables well enough to use native query.&nbsp; Can anyone lend a hand as to where the task "status" is kept and how to query for this?&nbsp; I am using Activiti 5.7.</SPAN><BR /><BR /><SPAN>Also, is there a way to do an exclusion query in the TaskQueryService?&nbsp; For example, how do I query for all tasks with a name NOT equal to "Review Task".</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>- Shannon</SPAN></BODY></HTML> Tue, 15 Jan 2013 16:17:08 GMT srobinson 2013-01-15T16:17:08Z How do you query for completed tasks https://connect.hyland.com/t5/alfresco-archive/how-do-you-query-for-completed-tasks/m-p/144749#M101210 I am trying to query for completed tasks and I can't find a way to do it through the TaskQueryService and I do not know the database tables well enough to use native query.&nbsp; Can anyone lend a hand as to where the task "status" is kept and how to query for this?&nbsp; I am using Activiti 5.7.Also, is ther Tue, 15 Jan 2013 16:17:08 GMT https://connect.hyland.com/t5/alfresco-archive/how-do-you-query-for-completed-tasks/m-p/144749#M101210 srobinson 2013-01-15T16:17:08Z Re: How do you query for completed tasks https://connect.hyland.com/t5/alfresco-archive/how-do-you-query-for-completed-tasks/m-p/144750#M101211 <HTML><HEAD></HEAD><BODY><SPAN>As soon as a Task is completed, it's removed from the task-table (the RU in the ACT_RU_TASK table name, stands for runtime). If your history-level is configured correctly (see user guide), the task will be present in the ACT_HI_TASKINST table, query able using historyService.createHistoricTaskQuery().</SPAN></BODY></HTML> Tue, 15 Jan 2013 16:38:50 GMT https://connect.hyland.com/t5/alfresco-archive/how-do-you-query-for-completed-tasks/m-p/144750#M101211 frederikherema1 2013-01-15T16:38:50Z Re: How do you query for completed tasks https://connect.hyland.com/t5/alfresco-archive/how-do-you-query-for-completed-tasks/m-p/144751#M101212 <HTML><HEAD></HEAD><BODY><SPAN>Great … that helps clears things up a bit!</SPAN><BR /><BR /><SPAN>- Shannon</SPAN></BODY></HTML> Wed, 16 Jan 2013 19:09:15 GMT https://connect.hyland.com/t5/alfresco-archive/how-do-you-query-for-completed-tasks/m-p/144751#M101212 srobinson 2013-01-16T19:09:15Z