Hello CMDBuild Team! I would like to ask a question about a problem we face.
We have openMAINT installed and added data and relations for Rooms, Floors, Buildings and Complexes. Every time we add a Room, we then relate it only to a Floor and automatically it "inherits" the existing relations (from the floor) to the Building and the Complex.
Now we add "Assets" and relate them to Rooms. We expect them to be automatically related to Floors, Buildings and Complexes. However, they do not "inherit" the relations of the Rooms. This is exactly what we are looking for: if we associate an asset to a room (or a person to a room), we need it to automatically associate to the appropriate higher level Site entities (Floor, Building, Complex).
I was wondering, is non-inheritance the normal behavior?
Is there a psql function running for the inheritance OR does it depend on the settings of the "domains" (relations)?
Could you kindly provide me further info on the above? Thank you, Dimitris
When you enter from the openMAINT GUI the card for an asset, you have to select cascade the relations with Complex (if it exists), Building, Floor, Room, and this way all relationships are created correctly. If you remove from the asset card the Reference attributes with Complex, Building and Floor (but there would be many impacts on openMAINT) you should fill them through database triggers. CMDBuild Team
What do you mean by saying "select cascade the relations with Complex"? In the Asset card creation I do not see any box or button or other option for cascading relations. Maybe do you mean to firstly select the Complex from the drop down list, then select the Building from the drop down list, then the floor and then the room again from the drop down list? Because that wouldn't be automatically!
Thank you once again! Dimitris
Previously Tecnoteca wrote:
When you enter from the openMAINT GUI the card for an asset, you have to select cascade the relations with Complex (if it exists), Building, Floor, Room, and this way all relationships are created correctly. If you remove from the asset card the Reference attributes with Complex, Building and Floor (but there would be many impacts on openMAINT) you should fill them through database triggers. CMDBuild Team
Yes I mean firstly select the Complex from the drop down list, then select the Building from the drop down list (filtered on the chosen complex), then the floor (filtered on the chosen building) and then the room (filtered on the chosen floor).
Normally this is the most effective way because if there were thousands of rooms would be very difficult to choose a room from a list so extensive.