Get count of Associations for a folder and asset

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.

ajendra

I am trying to get the number (count) of associations for an asset/folder by using the reference type in Java.

But, I don't have an idea how to achieve this. 

I have written a query to get this, but this is from alfresco tables. Also, this query fetches the associations only for Asset types not for folders. 

Here is the query what I have written

SELECT COUNT(*) FROM alf_node  aNode

INNER JOIN   alf_node_assoc ana   ON  aNode.id = ana.source_node_id

INNER JOIN  alf_qname aqn   ON   ana.type_qname_id = aqn.id

WHERE aNode.uuid = "897f6e7a-a9bf-46ea-95b8-b9hyyji7hhuu8"

AND  aqn.local_name = "imageReference";

I need this result but, from java code and also, the above query works for asset but not for folders.

I don't need the records, I just need the count of associations

Any help will be really appriciated.

Thanks in advance

angelborroy

You may try using NodeService.getSourceAssocs() or NodeService.getTargetAssocs() methods.

http://dev.alfresco.com/resource/AlfrescoOne/5.0/PublicAPI/org/alfresco/service/cmr/repository/NodeService.html#getSourceAssocs(org.alfresco.service.cmr.repository.NodeRef,%20org.alfresco.service.namespace.QNamePattern)

http://dev.alfresco.com/resource/AlfrescoOne/5.0/PublicAPI/org/alfresco/service/cmr/repository/NodeService.html#getTargetAssocs(org.alfresco.service.cmr.repository.NodeRef,%20org.alfresco.service.namespace.QNamePattern) 

In order to get every QNamePattern use QNamePattern.MATCH_ALL for the second argument (http://dev.alfresco.com/resource/AlfrescoOne/5.0/PublicAPI/org/alfresco/service/namespace/RegexQNamePattern.html#MATCH_ALL)