...
TMS table name | TMS field name | CSpace field name | notes |
|---|---|---|---|
ConXrefs | constituentID | contentPerson | reference to Person Authority |
sql query
view:
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT
CAST(o.objectID AS VARCHAR) objectID,
x.constituentID contentPerson
FROM
ConXrefs x
JOIN roles r ON x.roleID = r.roleID
JOIN objects o ON x.ID = o.objectID
JOIN constituents c ON x.constituentID = c.constituentID
WHERE
x.tableID = 108
AND x.active = 1
AND o.IsVirtual = 0 AND o.IsTemplate = 0
AND c.constituentTypeID = 1
AND lower(r.ROLE) IN ('subject')
;
|
notes
Place depicted extract
field mapping
TMS table name | TMS field name | CSpace field name | notes |
|---|---|---|---|
ThesXrefs | termID | contentPlace | reference to Place Authority |
sql query
view:
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT
CAST(o.objectID AS VARCHAR) objectID,
x.termID contentPlace
FROM
ThesXrefs x
JOIN ThesXrefTypes t ON x.thesXrefTypeID = t.thesXrefTypeID
JOIN Objects o ON x.ID = o.objectID
WHERE
x.tableID = 108
AND x.active = 1
AND o.IsVirtual = 0 AND o.IsTemplate = 0
AND x.thesXrefTableID = 346
AND lower(t.thesXrefType) IN ('subject')
;
|