SQL query to fetch groups

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

nikes

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                 VERSION    NS_ID            local_name
107832015    0      107831558    authorityContainer
107832017           0      107831558   authorityName
107831592    1      107831554     authorityName
107831595    1      107831554    authorityContainer
107834322    0      107831558   authorityDisplayName
‍‍‍‍‍‍‍‍

Does this mean alfresco makes use of two different STORES to manage groups?
URI for NS_ID 107831554  = http://www.alfresco.org/model/user/1.0
URI for NS_ID 107831558  = http://www.alfresco.org/model/content/1.0

Our system has gone through many upgrades since 2.1 version and currently we using 3.4.x.

Thanks

andy

Hi

Alfresco 4 supports SQL queries to find authorities.

Andy