The Higher Education and Research forge

Home My Page Projects Code Snippets Project Openings

Snippet Library

Utilisation de la fonctionnalité QShare d'Alfresco

Sample Code (HOWTO)
File Management
GNU General Public License

-- BDD : MySQL
-- Auteur :

Versions Of This Snippet:

Snippet ID Download Version Date Posted Author Delete
41.02016-04-22 12:45Xavier Rouviere Delete

Download a raw-text version of this code by clicking on “Download Version”

Latest Snippet Version: 1.0

-- Sélection des ID dans alf_qname
SELECT * FROM alfresco.alf_qname
where local_name like '%share%';
ID	version	ns_id	local_name 
804	0		45		sharedId
805	0		45		sharedBy
806	0		45		shared

-- QuickShare
select count(*) from alf_node_aspects where qname_id=806 --shared

-- qui partage ?
select  p.string_value partageur ,count(p.node_id)
from alf_node_aspects a, alf_node_properties p
where  a.qname_id=806 --shared
and a.node_id=p.node_id
and p.qname_id = 805 -- shareBy
and string_value is not null
group by partageur

-- de quand date (date de modification) les documents partagés ?
select count( distinct, substring(audit_modified, 1,7) as datelbl 
from alf_node n, alf_node_aspects a
where  a.qname_id=806
group by datelbl

Add a new version

You can submit a new version of this snippet if you have modified it and you feel it is appropriate to share with others.