...
Table of Contents | ||
---|---|---|
|
Page Tree | ||||
---|---|---|---|---|
|
Collection Objects extract
...
Object Status
field mapping
TMS table name | TMS field name | CSpace field name | notes |
---|---|---|---|
Objects | objectStatusID | Object Status (PAHMA schema) | FK to ObjectStatuses |
StatusFlags | FlagID | Object Status (PAHMA schema) | FK to FlagLabels |
sql query
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT
CAST(o.objectID AS VARCHAR) objectID,
s.ObjectStatus pahmaObjectStatus
FROM
Objects o
LEFT OUTER JOIN ObjectStatuses s ON o.objectStatusID = s.objectStatusID
WHERE
o.IsVirtual = 0 AND o.IsTemplate = 0
AND o.objectStatusID IS NOT NULL
UNION ALL
SELECT
CAST(sf.objectID AS VARCHAR) objectID,
fl.FlagLabel pahmaObjectStatus
FROM
StatusFlags sf
LEFT OUTER JOIN FlagLabels fl ON sf.FlagID = fl.FlagID
WHERE
fl.FlagID IS NOT NULL
ORDER BY objectID
|