...
TMS table name | TMS field name | CSpace field name | notes |
---|---|---|---|
ObjectPackages | name | title |
|
ObjectPackages | notes | scopeNote |
|
ObjectPackages | owner | owner | FK to Users; reference to Person Authority |
Objects | objectNumber | title | for Burial Lot |
sql query
view: cs_groups (refreshed 2012-05-11)
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT CAST(p.objectPackageID AS VARCHAR) groupID, p.name title, p.notes scopeNote, (CASE WHEN u.MTB_ConstituentID = -1 THEN NULL ELSE u.MTB_ConstituentID END) owner FROM ObjectPackages p LEFT OUTER JOIN Users u ON p.owner = u.login UNION ALL SELECT 'bur' + CAST(o.objectID AS VARCHAR) groupID, 'Burial lot ' + o.objectNumber title, null scopeNote, null owner FROM Objects o WHERE o.IsTemplate = 0 and o.IsVirtual=1 and o.DepartmentID = 34 ; |
...