Versions Compared

Old Version 91

changes.mady.by.user John W Keller

Saved on

compared with

New Version 92

changes.mady.by.user John W Keller

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
sql
sql
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

...

Cultural group depicted extract

field mapping

TMS table name

TMS field name

CSpace field name

notes

TextEntries

textEntry

contentNote contentPeople

where textTypeID is 85 110 or 111

sql query

view: (NEEDS UPDATE)

Code Block
sql
sql
SELECT
 CAST(o.objectID AS VARCHAR) objectID,
 t.TextEntry,
 tt.TextType, contentPeople
FROM
 TextEntries t
 JOIN Objects o ON t.ID = o.objectID
 JOIN TextTypes tt ON t.TextTypeID = tt.TextTypeID
WHERE
 t.TextDate,
 t.AuthorConIDtableID = 108
 AND o.IsVirtual = 0 AND o.IsTemplate = 0
 AND t.TextTypeID IN (110, 111)
;

notes

Content note extract

field mapping

TMS table name

TMS field name

CSpace field name

notes

TextEntries

textEntry

contentNote

where textTypeID is 85

sql query

view: (NEEDS UPDATE)

Code Block
sql
sql

SELECT
 CAST(o.objectID AS VARCHAR) objectID,
 t.TextEntry contentNote
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 = 85
;

notes