So I currently have one node, campaigns, which has a field/association that references the user table called authorised_by.
In code I can set the association like this:
nodeService.createAssociation(mcdNodeRef, newAuthority, CustomContentModel.ASSOC_MCD_CAMP_AUTHORITY);
Now I need to basically reverse engineer this process and get the value of the association back out of the alfresco DB but there is no getAssociation method and can't seem to work it out.
Thanks
Solved it myself, here is solution: