Versions Compared

Key

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

...

view:

Code Block
sql
sql

notes

Field collectors extract

field mapping

TMS table name

TMS field name

CSpace field name

notes

ConXrefs

ID

reference to Object

 

ConXrefs

constituentID

fieldCollector

reference to Person or Organization

sql query

view:

Code Block
sql
sql

SELECT
 o.objectID,
 x.constituentID fieldCollector
FROM
 ConXrefs x
 JOIN roles r ON x.roleID = r.roleID
 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 lower(r.ROLE) IN ('collector', 'secondary collector', 'tertiary collector')
;

notes