topic Re: 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/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 trademak 2013-04-09T15:07:44Z 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