AnsweredAssumed Answered

SQL query to fetch groups

Question asked by nikes on Oct 17, 2012
Latest reply on Oct 17, 2012 by andy
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

Outcomes