Hi all,
I'm using Insight to start to build an IT CMDB, which needs to includes a hierarchy of location data: Campus - Building - Location
These fields are on the customer portal and I want these fields to be filtered - eg when selecting campus 1, only buildings at campus 1 are available to select. When selecting building 2, only locations in building 2 are available to select.
Campus - has one or more buildings, linked via an inbound reference to buildings
Buildings - have multiple locations, linked via an inbound reference to locations
What I'm missing is some IQL to filter based upon the inbound/outbound references - can't figure out what is required.
Thanks in advance.