topic Re: Bi-Directional Associations in Alfresco Archive

Bi-Directional Associations

stevewickii — Wed, 17 Sep 2008 05:06:17 GMT

I am using Alfresco 2.9.0B build 683.I need to create a bidirectional association between a cmroduct and a cmest. All my attempts have failed. Please help.I followed these directions: http://wiki.alfresco.com/wiki/Data_Dictionary_Guide#Non-Child_AssociationscustomModel.xml<?xml version="1.0

Re: Bi-Directional Associations

stevewickii — Tue, 23 Sep 2008 21:19:27 GMT

Well, I have tried a bunch of stuff without success.

I tried adding <role> tags for the <source> and <target>. Still the fsest and fs:crop nodes do not have references to the fsroduct.

I tried defining a common base content-type for fsroduct, fs:crop and fsest named fs:related, which defines the association fs:crops, fsests and fsroducts. This got around the duplicate name violation, but still didn't solve my problem. Adding an fs:crop to an fsroduct's fs:crops property does not add the fsroduct to the fs:crop's fsroducts property.

Re: Bi-Directional Associations

alr — Wed, 24 Sep 2008 07:45:05 GMT

Hi Steve

I have stumbled across the same problem and could not get it to work either. Interestingly, when taking a quick look at the org.alfresco.repo.domain.NodeAssoc interface, you can read in the first comment:


 * Represents a generic association between two nodes.  The association is named
 * and bidirectional by default.
‍‍‍‍

But thats all about explanations - also, trying to show the association in the web-client-config-custom.xml file for the target only results in an error in the alfresco log (the below written association is only defined in cns:text)


   <config evaluator="node-type" condition="cns:text">
      <property-sheet>
         <show-association name="cns:textTemplateAssoc" />
      </property-sheet>
   </config>
   
   <config evaluator="node-type" condition="cns:textTemplate">
      <property-sheet>
         <show-association name="cns:textTemplateAssoc" />
      </property-sheet>
   </config>
‍‍‍‍‍‍‍‍‍‍‍‍‍


09:33:13,450 User:admin WARN  [component.property.UIAssociation] Failed to find association definition for association 'cns:textTemplateAssoc'
‍‍‍

Doesn't really help, but shows my tries up until now. Good luck for more work!

Re: Bi-Directional Associations

stevewickii — Wed, 24 Sep 2008 21:49:01 GMT

Thanks alr.

I reviewed about 60 Alfresco JIRA tickets, and found the following, which seem to be related to this problem.

https://issues.alfresco.com/jira/browse/ALFCOM-588
https://issues.alfresco.com/jira/browse/ALFCOM-1336
https://issues.alfresco.com/jira/browse/ENH-28

I voted on all of these tickets and added them to my watch list. Please do the same if you are interested in getting this issue fixed.

Ticket ALFCOM-588 makes it sound like it is already possible to use the NodeService class to get the Source node from the Target node given an association ref. A quick look at NodeServiceImpl.java (Alfresco 2.9.0B build 683) reveals that this functionality is not available.

NodeServiceImpl.java

    /**
     * @throws UnsupportedOperationException always
     */
    public List<AssociationRef> getSourceAssocs(NodeRef sourceRef, QNamePattern qnamePattern)
    {
        // This operation is not supported for a version store
        throw new UnsupportedOperationException(MSG_UNSUPPORTED);
    }‍‍‍‍‍‍‍‍

It looks like peer-associations are unidirectional as of Alfresco 2.9.0B build 683.

Re: Bi-Directional Associations

stevewickii — Wed, 24 Sep 2008 22:05:28 GMT

Here's one option to work around the problem. This is by no means a fix.

When creating Presentation Templates or Scripts/Web Scripts, use the companyhome.childrenByLuceneSearch[] feature or search.luceneSearch() respectively, to search for the Source node(s) by content type and association name.

Examples

Given that content types fsroduct and fs:crop extend cm:content, and fsroduct defines an association to fs:crop named "fs:crops"…

Here is a FreeMarker Presentation Template for fs:crop nodes (Target node) named crop_info.ftl, which displays the name of the crop and lists out a link to each associated fsroduct (Source node).

crop_info.ftl

<#– Shows some Crop info about the current document –>
<#if document?exists>
   <h4>Crop Info:</h4>
   <table>
   <tr><td><b>Name:</b></td><td>${document.name}</td></tr>
   <tr><td><b>Products:</b></td><td>
   <table>
      <#list companyhome.childrenByLuceneSearch["+TYPE:\"fs:product\""] as product>
         <#list product.assocs["fs:crops"] as crop>
         <#if crop.name == document.name>
         <tr><td><a href="/alfresco/n/showDocDetails/workspace/SpacesStore/${product.id}">${product.name}</a></td></tr>
         </#if>
      </#list>
      </#list>
   </table>
   </td></tr>
    </table>
<#else>
   No document found!
</#if>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Bi-Directional Associations

stevewickii — Thu, 25 Sep 2008 16:40:37 GMT

I checked out the Alfresco project from subversion, and verified that NodeServiceImpl.getSourceAssocs() is not implemented to return source associations (it is implemented to throw an UnsupportedOperationException). That means that as of Alfresco Labs 3b, bidirectional associations are still unsupported.

Re: Bi-Directional Associations

alr — Mon, 29 Sep 2008 15:15:59 GMT

Hey Steve,

your fix still implies, that one adds the bi-directional relationship manually. This is not really what one would want. The ideal case would be some sort of hook, which triggers, when an object from my domainModel gets edited and automatically the second association is created. I've peered a little bit around in the source today, but haven't found anything what would do somethink like this - but perhaps I am just blind.

Help is always highly appreciated.

Regards,
Alexander

Re: Bi-Directional Associations

alr — Mon, 06 Oct 2008 16:17:32 GMT

Hey,

actually the solution is pretty simple.


public class RuleTriggerBidirectionalAssoc extends RuleTriggerAbstractBase
   implements NodeServicePolicies.OnDeleteAssociationPolicy, NodeServicePolicies.OnCreateAssociationPolicy {

   public void onDeleteAssociation(AssociationRef nodeAssocRef) {
         nodeService.removeAssociation(nodeAssocRef.getTargetRef(), nodeAssocRef.getSourceRef(), 
               getReverseQnameAssociationName(nodeAssocRef.getTypeQName()));
   }

   public void onCreateAssociation(AssociationRef nodeAssocRef) {
         nodeService.createAssociation(nodeAssocRef.getTargetRef(), nodeAssocRef.getSourceRef(), 
               getReverseQnameAssociationName(nodeAssocRef.getTypeQName()));
   }

   public void registerRuleTrigger() {
      this.policyComponent.bindAssociationBehaviour(QName.createQName(NamespaceService.ALFRESCO_URI, "onCreateAssociation"), this, 
            new JavaBehaviour(this, "onCreateAssociation"));
      
      this.policyComponent.bindAssociationBehaviour(QName.createQName(NamespaceService.ALFRESCO_URI, "onDeleteAssociation"), this, 
            new JavaBehaviour(this, "onDeleteAssociation"));
      
   }

}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The logic for the getReverseQnameAssociationName() method needs to pick out the right reverse association. All you need afterwards is a little spring configuration addition in some bidrectional-assoc-context.xml file, which is also put in the jar.
For performance issues you should check, that you only do update associations which are covered in your own model for example - but those checks can be added quite quickly.


<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE beans PUBLIC '-//SPRING//DTD BEAN//EN' 'http://www.springframework.org/dtd/spring-beans.dtd'>
<beans>
   <bean id="on-association-change-trigger" class="org.test.alfresco.repo.rule.trigger.RuleTriggerBidirectionalAssoc" 
      parent="rule-trigger-base" />
</beans>
‍‍‍‍‍‍‍‍

And that's it basically. I only stumbled upon triggers by incident, I have to admit. 🙂

Re: Bi-Directional Associations

stevewickii — Mon, 06 Oct 2008 21:43:14 GMT

Great info Alexander. I can't try it right now, because I'm working on another issue, but I'll let you know how it works on my system as soon as I am able.

Thanks!

Re: Bi-Directional Associations

adstrim — Mon, 22 Dec 2008 23:45:37 GMT

I applied your code and it worked fine. Thanks.
To make it generic and bidirectional I use QName like this sample:A2B and sample:B2A and I implement getReverseQnameAssociationName


    public QName getReverseQnameAssociationName(QName qName) {
        String reverseLocalName = new StringBuffer(qName.getLocalName()).reverse().toString();
        QName reverseQName = QName.createQName(qName.getNamespaceURI(), reverseLocalName);
        return reverseQName;
    }
‍‍‍‍‍‍‍

However there is nothing to impose the one to one constraint. Meaning another instance of A can associate itself to b and now there is no reverse association for A2B. (Two A are associated to B and B points only to one of them) unless you make the other relationship readonly


        <property-sheet>
            <show-association name="sample:s2c" read-only="true" />
        </property-sheet>
‍‍‍‍‍

Also this constraint imposes to have a reverse association for all associations defined in Alfresco. To remove such a restriction we can catch and ignore the corresponding exception


    public void onDeleteAssociation(AssociationRef nodeAssocRef) {
        try {
            nodeService.removeAssociation(nodeAssocRef.getTargetRef(), nodeAssocRef.getSourceRef(), getReverseQnameAssociationName(nodeAssocRef.getTypeQName()));
        } catch (IllegalArgumentException exception) {
            if (exception.getMessage().indexOf(NOT_DEFINED_EXCEPTION_MESSAGE) == -1)
                throw exception;
            // otherwise ignore it
        }
    }

    public void onCreateAssociation(AssociationRef nodeAssocRef) {
        try {
            nodeService.createAssociation(nodeAssocRef.getTargetRef(), nodeAssocRef.getSourceRef(), getReverseQnameAssociationName(nodeAssocRef.getTypeQName()));
        } catch (IllegalArgumentException exception) {
            if (exception.getMessage().indexOf(NOT_DEFINED_EXCEPTION_MESSAGE) == -1)
                throw exception;
            // otherwise ignore it
        }
    }
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Bi-Directional Associations

omer_i — Mon, 21 Dec 2009 19:49:19 GMT

Hi, I followed the way mentioned in the bottom to achieve bidirectional associations.

Although Associations are working fine but it creates a problem… I m not able to version the document. i.e. I cant apply versionable aspect on the document which is overridden with this new association… It throws this error

"Failed to apply the 'versionable' aspect to the document due to system error: Failed to execute transaction-level behaviour public abstract void org.alfresco.repo.node.NodeServicePolicies$OnAddAspectPolicy.onAddAspect(org.alfresco.service.cmr.repository.NodeRef,org.alfresco.service.namespace.QName) in transaction ed4e396b-effb-4954-a51c-23b51cd50b71"

Any ideas how to resolve this….

Thanks,
Omer

Re: Bi-Directional Associations

checco — Mon, 20 Feb 2012 17:09:32 GMT

Hi to all, i'am new to Alfresco.

The bug https://issues.alfresco.com/jira/browse/ALFCOM-588 is still open! and it seems there isn't any activity related to.

Anyone have some news? Actually i don't need this feature but probably in next future i'll need.

Cheers
Francesco.

Re: Bi-Directional Associations

clementus — Thu, 05 Oct 2017 07:08:56 GMT

Hi everyone,

I created a control form to handle bidirectional association.

Just email me to get my code.