Hi there, @jeffrey.j.obrien… although it does not address your specific question, your post reminded me of this post, and I am wondering if my first response in this thread might be useful in your situation…
Anyway, I didn’t think it could hurt to post that link as food for thought, and I hope it helps.
Hey, @jeffrey.j.obrien… I’m stoked to hear that my response in the other thread was useful for you.
About your follow-up question, I’m getting stuck on the fact that there doesn’t appear to be anything that defines an asset as a location. So, from a data perspective, the arm wand (which is obviously not a location) is the same as Singapore Parts Store. Oh, and Singapore Parts Store is kind of a sub-location of Singapore HQ, which seems to complicate matters a bit more.
The above being said, there doesn’t seem to be an easy way to remove Singapore HQ and Singapore Parts Store from the lists unless they are explicitly specified in the user interface as the “locations” from which the assets are being removed or there is a field in the Assets data type that defines an asset as a location. Adding the new “location” (parts room 2) to the lists could be easy enough because I’m assuming it is specified as an input of some sort. But again, I’m not sure how to remove the existing locations given your current setup, assuming I am understanding that setup correctly (which could easily not be the case).
Take the bottom record for example - the HVAC pump is attached to the HVAC cooling system, which is part of the HVAC system in the board room, on the 12th floor of building 1.
Let’s say I want to move the HVAC system from the board room to the men’s toilet. I need to remove the Building 1, Floor 12, and Board Room records from the downstream components of the HVAC system and everything below it. Well that is just the downstream components on the board room (its parent) above it.
When I move it, I need to add the new parent’s downstream records.
Here’s how I did it:
Created a database trigger to detect when the asset is moved (basically when the parent asset changes.)