...
view:
| Code Block | ||||
|---|---|---|---|---|
| ||||
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 | ||||
|---|---|---|---|---|
| ||||
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')
;
|