...
TMS table name | TMS field name | CSpace field name | notes |
|---|---|---|---|
Locations | Active | locationStatus | convert from '1/0' to 'active/inactive' to used in dropdown in UI |
Locations | LocationID | shortIdentifier | numeric value, prepended with 'sl' |
Locations | LocationString | displayName |
|
Locations | Site | Site |
|
Locations | Room | Room |
|
Locations | UnitType | UnitType |
|
Locations | UnitNumber | UnitNumber |
|
Locations | UnitPosition | UnitPosition |
|
sql query
| Info |
|---|
NB: Query not working yet, placeholder just for show! Do not use! |
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT l.LocationID shortIdentifier, (case when l.active = 1 then 'active' else 'inactive' end) locationStatus, l.LocationString displayName, l.Site Site, l.Room Room, l.UnitType UnitType, l.UnitNumber UnitNumber, l.UnitPosition UnitPosition FROM locations l ; |
...