Many-to-Many Relationship Between Objects and References
The ability to use a Many to many (m2m) relationship was in demand years ago. Now, this functionality is available in DCM 5.0 GA + versions.
M2M was implemented as part of AppBase's ability to support many-to-many relationships. Speaking in DB language this functionality is implemented via a third table.
Let's see the example below How to start to work with m2m?
Data Model Builder
DCM supports systems and other reference objects to relate to a business object. The ability to set the cardinality is available only when the object is added to the mode. If you need to change the cardinality, you MUST delete the old relationship, add a new one, and set the new cardinality. Any change to cardinality needs to be deployed. MDM has some restrictions to set a cardinality for objects (see Limitations below).
- Add the Reference Object to the model.
- Change the Cardinality to 'Many to many' between the Business Object (Exclusive Split) and the Reference Object (Lawyers-External Party).
Form Builder
This component is a field that can be added to a Form and it works with many values.
- Add the new attribute (Lawyers BO) to the form Section.
- Set the necessary Properties.
- Check it on Preview.
Search Builder
This component is a tag field in a search panel.
- Add a new attribute to a grid and/or search sections.
- Set necessary properties for m2m column in a grid
.....
Page Builder
- Create a new detail page or clone the default one.
- Add the field from the MDM Summary Field in the Toolbox to the Summary panel
- Configure the settings of the widget
- Set the new Detail Page for the case type
- In runtime, the detail page will look like this
Limitations
- A reference object as view couldn't reference via m2m relationship.
- A reusable object as view couldn't reference via m2m relationship.