...
| 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')
;
|
notes
Associated cultural group extract
field mapping
TMS table name | TMS field name | CSpace field name | notes |
|---|---|---|---|
TextEntries | textEntry | assocPeopleNote | where textTypeID is 32, 49, 97, or 99 |
TextEntries | textType | assocPeopleType | where textTypeID is 49 |
sql query
view:
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT
CAST(o.objectID AS VARCHAR) objectID,
t.TextEntry assocPeopleNote,
(case when t.textTypeID = 49 then 'nagpraCulturalAffiliation' end) assocPeopleType
FROM
TextEntries t
JOIN Objects o ON t.ID = o.objectID
JOIN TextTypes tt ON t.TextTypeID = tt.TextTypeID
WHERE
t.tableID = 108
AND o.IsVirtual = 0 AND o.IsTemplate = 0
AND t.TextTypeID IN (32, 49, 97, 99)
;
|