Ok, had a crack at the code myself, but really not sure why it's not working. I have a relationship setup between a member and a document, I then have the following setup to detect the deletion of a node and to remove any relationships defined on that node:

public
 
 class RelationshipAppBase : ApplicationBase
{
 
public RelationshipAppBase()
{
 
CMSNode.AfterDelete += new EventHandler<DeleteEventArgs>(CMSNode_AfterDelete);
}
 
protected void CMSNode_AfterDelete(object sender, DeleteEventArgs e)
{
 
// Cleanup orphan relationships
 
var node = sender as CMSNode;
 
if (node == null)
 
return;
 
var relations = Relation.GetRelations(node.Id);
 
foreach (var relation in relations)
{
relation.Delete();
}
}
}

Debugging, it hits the event handler, but the call to Relation.GetRelations always returns an empty array. I've also tried it from both ends (ie delete the member first, or delete the document first) but the list always seems to be empty. Anybody got any ideas why this might be?

Many thanks

Matt

Ahhhhh. Worked it out. My problem was I didn't have a RelationType defined in the DB. Guess I got a little confused with the documentation I was following as nowhere seems to say you need to setup your relationTypes first. After installing the relation type package and defining the my relations, it all worked fine.

Matt

In fact, now that I've defined the relationship type, it does actualy clean up after itself. Maybe there needs to be something to prevent a relationship from being created with an invalid relationship type?

Matt

is working on a reply...