topic Using 5.11 native sql query, how to retrieve results in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/using-5-11-native-sql-query-how-to-retrieve-results/m-p/130063#M91392 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to use a query using native query, this the query I am trying to use.</SPAN><BR /><SPAN>Select TASK_DEF_KEY_, count(*) count from ACT_HI_TASKINST where delete_reason_ = 'completed' group by TASK_DEF_KEY_;</SPAN><BR /><SPAN>How can I retrieve the count which is given as an alias for the no.of&nbsp; tasks that is completed for a specific task definition?</SPAN><BR /><BR /><SPAN> List&lt;HistoricTaskInstance&gt; repo= historyService.createNativeHistoricTaskInstanceQuery().sql("Select TASK_DEF_KEY_, count(*) count from ACT_HI_TASKINST where delete_reason_ = 'completed' group by TASK_DEF_KEY_").list();</SPAN><BR /><SPAN>for(int n=0; n&lt; repo.size(); n++)</SPAN><BR /><SPAN>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;taskName = repo.get(n).getTaskDefinitionKey(); </SPAN><BR /><SPAN>&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; // Want to retrieve count, not sure how to</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</SPAN></BODY></HTML> Sun, 07 Apr 2013 13:45:19 GMT studious 2013-04-07T13:45:19Z Using 5.11 native sql query, how to retrieve results https://connect.hyland.com/t5/alfresco-archive/using-5-11-native-sql-query-how-to-retrieve-results/m-p/130063#M91392 I am trying to use a query using native query, this the query I am trying to use.Select TASK_DEF_KEY_, count(*) count from ACT_HI_TASKINST where delete_reason_ = 'completed' group by TASK_DEF_KEY_;How can I retrieve the count which is given as an alias for the no.of&nbsp; tasks that is completed for a sp Sun, 07 Apr 2013 13:45:19 GMT https://connect.hyland.com/t5/alfresco-archive/using-5-11-native-sql-query-how-to-retrieve-results/m-p/130063#M91392 studious 2013-04-07T13:45:19Z Re: Using 5.11 native sql query, how to retrieve results https://connect.hyland.com/t5/alfresco-archive/using-5-11-native-sql-query-how-to-retrieve-results/m-p/130064#M91393 <HTML><HEAD></HEAD><BODY><SPAN>Why don't you use the count() method then?</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Tue, 09 Apr 2013 15:07:44 GMT https://connect.hyland.com/t5/alfresco-archive/using-5-11-native-sql-query-how-to-retrieve-results/m-p/130064#M91393 trademak 2013-04-09T15:07:44Z