I'm new to insight and I'm trying to figure out the best way to set up my objects. I have branches and cost centers. A branch can have multiple cost centers but a cost center can only have one branch. How do I set this up so when I look at the branch I can see all of the cost centers related to it and when I look at the cost center I can see the branch it relates to?
You can configure the attribute that holds the link and set the cardinality, so for your cost centers set the cardinality to maximum 1 and on your branch just use the default, which is unlimited links.
Hi,
It is possible to have an attribute in the Branch that points out all the connected Cost centers and at the same time have an attribute in Cost center that keeps track on the connected Branch. However, I would not advise you to do that since you will need to update both object types whenever you update the cost center for a Branch.
Easiest to handle is to let the Cost Center objects keep track on which Branch it is connected to.
To be able to see the connected Cost centers for a specific Branch, you can look in the object's view -> Inbound references.
And to search for a Branch that has a specific Cost center, you would could query something like this in the Branch object type:
object having inboundReferences(objectType="Cost Center" and "CostCenterId"=1234)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.