Snippet Library
Utilisation de la fonctionnalité QShare d'Alfresco | |
| Type: Sample Code (HOWTO) |
Category: File Management |
| License: GNU General Public License |
Language: SQL |
Description: -- BDD : MySQL -- Auteur : xavier.rouviere@cirad.fr -- | |
Versions Of This Snippet:
| Snippet ID | Download Version | Date Posted | Author | Delete |
|---|---|---|---|---|
| 4 | 1.0 | 2016-04-22 12:45 | Xavier Rouviere | 
|
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 n.id), substring(audit_modified, 1,7) as datelbl
from alf_node n, alf_node_aspects a
where a.qname_id=806
and a.node_id=n.id
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.