1 Reply Latest reply on Sep 21, 2014 1:26 PM by dmshimself

    How to make recursive many to many relationship between BO?

    Dostalp Apprentice

      Hello.

      I would like to ask, if there is any workaround to do recursive many to many relationship between business objects in Service Desk 7.7. The regular way to do many-to-many relationship is to create new linking object which does not allow to create link between the same objects.

      I don't want to create special object with two one to many relation-ships substituting the mapping table for many-to-many relationship, because in that case, the relationship had to be created by creation of this substituting object with fulfilling both relation. And I want to create the link between them from any of them instead of creating some third object representing this relationship.

      Example: I have a common model of device (e.g. 4 port switch) which could be supported by more support models (e.g. 4 port switch, 8 port switch etc.). On the other hand, the particular support model could be used to support more common models. So there is a many to many relationship between common model and support model. Both objects, common and support model could be consider as "model", business object MODEL. So I need to create recursive many to many relationship on the object model. The relationship should create two model collection relation in the model object,

      • “models which could be supported collection”
      • “models which can be used for replacement collection”

      I would like to link particular common model with many support models simple by adding many models into the “models which can be used for replacement collection” and vice versa.

       

      The question is, if there is any workaround to create linking object linking the same objects. When attempt to do this, the error “The two objects selected must be different!”


      Thanks for the answer.