topic Re: SQL query to fetch groups in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/sql-query-to-fetch-groups/m-p/273391#M226521 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>Alfresco 4 supports SQL queries to find authorities.</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Wed, 17 Oct 2012 16:21:31 GMT andy 2012-10-17T16:21:31Z SQL query to fetch groups https://connect.hyland.com/t5/alfresco-archive/sql-query-to-fetch-groups/m-p/273390#M226520 Hello,I am trying to fetch list of groups using SQL.I have few questions:I ran this:select * from alf_qname where local_name like 'authority%';‍‍‍which returned:ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VERSION&nbsp;&nbsp;&nbsp; NS_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; local_name107832015 &nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 107831558 &nbsp;&nbsp;&nbsp;authorityContainer107832017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1078 Wed, 17 Oct 2012 15:13:11 GMT https://connect.hyland.com/t5/alfresco-archive/sql-query-to-fetch-groups/m-p/273390#M226520 nikes 2012-10-17T15:13:11Z Re: SQL query to fetch groups https://connect.hyland.com/t5/alfresco-archive/sql-query-to-fetch-groups/m-p/273391#M226521 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>Alfresco 4 supports SQL queries to find authorities.</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Wed, 17 Oct 2012 16:21:31 GMT https://connect.hyland.com/t5/alfresco-archive/sql-query-to-fetch-groups/m-p/273391#M226521 andy 2012-10-17T16:21:31Z