...
TMS table name | TMS field name | CSpace field name | notes |
---|---|---|---|
LocPurposes | LocPurpose | reasonForMove |
|
ObjLocations | AnticipEndDate | plannedRemovalDate |
|
ObjLocations | DateOut | removalDate |
|
ObjLocations | concat(Sublevel, SearchContainer, TempText, Approver) | currentLocationNote | |
ObjLocations | CrateID | currentLocationNote | (perhaps this should not be just a note...) |
sql query
view: cs_objectlocations (refreshed 2012-04-05 [may still need work])
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT j.ObjectNumber objectNumber, l.LocationString currLocation, o.Handler locationHandler, o.TransDate locationDate, p.LocPurpose reasonForMove, o.AnticipEndDate plannedRemovalDate, o.DateOut removalDate, o.Sublevel+o.SearchContainer+o.TempText+o.Approver+str(o.CrateID) currentLocationNote, l.LocationID locationShortID, (case when o.Inactive = 1 then 'active' else 'deleted' end) miscStatus FROM ObjLocations o JOIN Locations l ON l.LocationID = o.LocationID JOIN Objects j ON j.ObjectID = o.ComponentID JOIN LocPurposes p ON p.LocPurposeID = o.LocPurposeID ; |
...