Hi all —
We need to un-set the Home Locations for a group of objects without changing their current locations. I have an idea about how to go about this but was curious if other institutions have run into this problem or if there might be another way to do it.
The most obvious method AFAIK would be to zero out the Home locations columns in ObjComponents.
UPDATE oc
SET oc.HomeCrateID = NULL,
oc.HomeLevel = NULL,
oc.HomeLocationID = -1,
oc.HomeSublevel = NULL,
oc.SearchHomeContainer = NULL
FROM ObjComponents oc
WHERE /* whatever */
The alternative to this would be move the objects, via SQL, (I do not believe you can update the Home Location without changing the Current Location) to a “Virtual Home” location. This "Virtual Home” is simply a place holder that should never be used as
a Current Location which means we would then have to write a notification job that would alert us if any object that were accidentally “returned to home” to the Virtual Home. This isn’t a huge problem but it is one more daily notification that would need to
be tracked and managed by collections staff.
The major issue I have run into while testing the first option is the Crate Type text not being cleared from the Home Location column after the ObjComponents home location data was zeroed out. For example, if I run the above SQL on an object whose Home
Location includes a Crate then what we see after the update is this:
And I cannot figure out why or how the Crate Type value is still being populated into the Home Location column. Has anyone ever needed to unset Home Locations? How did you go about doing it?
We are running TMS 2010 and SQL Server 2008.
Thanks,
Scott
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.