...
- some annotationType field values set by query above
- TODO: update controlled list options for annotationType field
- TODO: include some data from TextEntries table in this query...?
Groups extract
to be imported into the Groups Procedure schema
field mapping
TMS table name | TMS field name | CSpace field name | notes |
|---|---|---|---|
ObjectPackages | name | title |
|
ObjectPackages | notes | scopeNote |
|
ObjectPackages | owner | owner | FK to Users; reference to Person Authority |
sql query
view: cs_groups
...
SELECT
p.objectPackageID groupID,
p.name title,
p.notes scopeNote,
(CASE WHEN u.MTB_ConstituentID = -1 THEN NULL ELSE u.MTB_ConstituentID END) owner
FROM
ObjectPackages p
LEFT OUTER JOIN Users u ON p.owner = u.login
;
notes
- "global" field does not need to be imported, per Michael (1/12/12)
Object-Group Relationship extract
field mapping
TMS table name | TMS field name | CSpace field name | notes |
|---|---|---|---|
ObjPkgList | ObjectID | reference to Object |
|
ObjPkgList | ObjectPackageID | reference to Group |
|
sql query
view: cs_objectgrouprelationships
...
SELECT
CAST(o.objectID AS VARCHAR) objectID,
o.objectPackageID groupID
FROM
objPkgList o
;