...
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT objectID, bibliography referenceNote FROM Objects WHERE bibliography is not null UNION ALL SELECT objectID, PubReferences referenceNote FROM Objects WHERE PubReferences is not null ; |
Annotations extract
under construction
field mapping
TMS table name | TMS field name | CSpace field name | notes | ||||
|---|---|---|---|---|---|---|---|
Objects | Edition | annotationNote |
| ||||
Objects | CuratorialRemarks | annotationNote |
| ||||
Components | PrepComments | annotationNote |
| ||||
ObjUserFields | FieldValue | annotationNote |
| TextEntries | ? | ? | TBD |
sql query
view: cs_annotations
...
- 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
...