Versions Compared

Key

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

...

Procedure

MMI Field name

CSpace field name

DB table.field

NXQL table:field

search
API

updated

Cataloging

Label

Caption

collectionobjects_mmi.caption

collectionobjects_mmi:caption

@

 

Accession number

Object Number

collectionobjects_common.objectnumber

collectionobjects_common:objectNumber

@

 

 

Description

Distinguishing Features

collectionobjects_common.distinguishingfeatures

collectionobjects_common:distinguishingFeatures

@

 

 

Collection category

Responsible Department (RF)(CL)

collectionobjects_common_responsibledepartments.item

collectionobjects_common:responsibleDepartments

@

 

 

Artifact Class

Artifact Class (URN)

collectionobjects_mmi.artifactclass

collectionobjects_mmi:artifactClass

@

 

Work Type

Work Type (URN)

collectionobjects_mmi.worktype

collectionobjects_mmi:workType

@

 

Overall dimensions

Dimension summary

measuredpartgroup.dimensionsummary

collectionobjects_common:measuredPartGroupList/0/dimensionSummary

@

 

 

Creation date

Display date

structureddategroup.datedisplaydate

collectionobjects_common:objectProductionDateGroupList/*/dateDisplayDate

@

 

 

 

Date association (URN)

structureddategroup.dateassociation

collectionobjects_common:objectProductionDateGroupList/*/dateAssociation

@

 

 

Material

Material (RF) (URN)

collectionobjects_mmi_mmimaterials.item .pos

collectionobjects_mmi:mmiMaterials

@

 

Authority: Content Entities

Content organization (RG)

shares the table name
contententitygroup

shares the table name
collectionobjects_mmi

 

 

 

 

Content entity (URN)

  .contententity

  :contentEntityList/*/contentEntity

@

 

 

 

Content entity type (CL)

  .contententitytype

  :contentEntityList/*/contentEntityType

@

 

 

Authority: Content Works

Content works (RG)

shares the table name
contentworkgroup

shares the table name
collectionobjects_mmi

 

 

 

Content work (URN)

  .contentwork

  :contentWorkList/*/contentWork

@

 

 

Content work type (CL)

  .contentworktype

  :contentWorkList/*/contentWorkType

@

 

Authority: Object Production Entities

Object Production Entity (RG)

shares the table name
objprodentitygroup

shares the table name
collectionobjects_mmi

 

 

 

Object production entity (URN)

  .objprodentity

  :objProdEntityList/*/objProdEntity

@

 

 

Object production role (CL)

  .objprodentityrole

  :objProdEntityList/*/objProdEntityRole

@

Acquisition

Credit line

Credit Line

acquisitions_common.creditline

 

 

 

Location

Current location

Current location (URN)

movements_common.currentlocation

movements_common:currentLocation

 

 

Wiki Markup
{composition-setup}{composition-setup}


...

Old schema

...

{toggle-cloak:id=a11}

Wiki Markup
{cloak:id=a11}

Procedure

MMI Field name

CSpace field name

DB table.field

NXQL table:field

Link to search?

link

updated

Cataloging

Label

Brief Description (RF)

collectionobjects_common_briefdescriptions.item .pos

collectionobjects_common:briefDescriptions

N

 

 

 

Description

Distinguishing Features

collectionobjects_common.distinguishingfeatures

collectionobjects_common:distinguishingFeatures

N

 

 

 

Content remarks

Inscription Content (RF)

collectionobjects_mmi_mmiinscriptioncontents.item .pos

collectionobjects_mmi:mmiInscriptionContents

N

 

 

 

Accession number

Object Number

collectionobjects_common.objectnumber

collectionobjects_common:objectNumber

N

 

 

 

Collection category

Responsible Department (RF)(CL)

collectionobjects_common_responsibledepartments.item

collectionobjects_common:responsibleDepartments

Y

 

 

 

Artifact class/ Work type (Categories)

Artifact class/ Work type (RG)

shares the table name artifactclassworktypegroup

shares the table name collectionobjects_mmi

 

 

 

Artifact Class

Artifact Class

collectionobjects_mmi.artifactclass

collectionobjects_mmi:artifactClass

Y

 

 

Work Type

Work Type

collectionobjects_mmi.worktype

collectionobjects_mmi:workType

Y

 

 

Dimensions

Dimensions (component)

 

shares the table name
collectionobjects_common

N

 

 

 

 

Dimension summary

measuredpartgroup.dimensionsummary

  :measuredPartGroupList/*/dimensionSummary

 

 

 

 

 

Measured part

measuredpartgroup.measuredpart

  :measuredPartGroupList/*/measuredPart

 

 

 

 

 

Value date (date)

dimensionsubgroup.valuedate

  :measuredPartGroupList//dimensionSubGroupList//valueDate

 

 

 

 

 

Measurement unit

dimensionsubgroup.measurementunit

  :measuredPartGroupList//dimensionSubGroupList//measurementUnit

 

 

 

 

 

Value (integer)

dimensionsubgroup.value

  :measuredPartGroupList//dimensionSubGroupList//value

 

 

 

 

 

Value qualifier (integer)

dimensionsubgroup.valuequalifier

  :measuredPartGroupList//dimensionSubGroupList//valueQualifier

 

 

 

 

Extent

Number of Objects (integer)

collectionobjects_common.numberofobjects

collectionobjects_common:numberOfObjects

N

 

 

 

Attribute: Format

Physical Description

collectionobjects_mmi.formats

collectionobjects_mmi:formats

N

 

 

Attribute: Technique

Technique (RF)

collectionobjects_mmi_mmitechniques.item .pos

collectionobjects_mmi:mmiTechniques

N

 

 

 

Attribute: Dimensions

Dimensions (component)

same as before?

 

N

 

 

 

Attribute: Display date

Production Date (component)

shares the table name
structureddategroup

shares the table name
collectionobjects_common

N

 

 

 

 

Display date

.datedisplaydate

  :objectProductionDateGroupList/*/dateDisplayDate

 

 

 

 

 

Association (URN)

.dateassociation

  :objectProductionDateGroupList/*/dateAssociation

 

 

 

 

 

dateEarliestScalarValue (date)

.dateearliestscalarvalue

  :objectProductionDateGroupList/*/dateEarliestScalarValue

 

 

 

 

 

dateLatestScalarValue (date)

.datelatestscalarvalue

  :objectProductionDateGroupList/*/dateLatestScalarValue

 

 

 

 

Attribute: Materials

Material (RF) (CL)

collectionobjects_mmi_mmimaterials.item .pos

collectionobjects_mmi:mmiMaterials

N

 

 

 

Attribute: Components

Object component name (RG)

shares the table name
objectcomponentgroup

shares the table name
collectionobjects_common

N

 

 

 

 

Object component name

  .objectcomponentname 

  :objectComponentGroupList/*/objectComponentName

 

 

 

 

 

Object component information

  .objectcomponentinformation

  :objectComponentGroupList/*/objectComponentInformation

 

 

 

 

Authority: Associated Entities

Associated organization (RG)

shares the table name assocorganizationgroup

shares the table name collectionobjects_common

Y

 

 

 

Associated organization (URN)

  .assocorganization

  :assocOrganizationGroupList/*/assocOrganization

 

 

 

 

 

Associated organization type (CL)

  .assocorganizationtype

  :assocOrganizationGroupList/*/assocOrganizationType

 

 

 

 

 

Associated organization note

  .assocorganizationnote

  :assocOrganizationGroupList/*/assocOrganizationNote

 

 

 

 

Authority: Associated Productions

Associated production (RG)

shares the table name assocproductiongroup

shares the table name collectionobjects_mmi

Y

 

 

 

Associated production (URN)

  .assocproduction 

  :assocProductionList/*/assocProduction

 

 

 

 

 

Associated production type (CL)

  .assocproductiontype

  :assocProductionList/*/assocProductionType

 

 

 

 

 

Associated production note

  .assocproductionnote 

  :assocProductionList/*/assocProductionNote

 

 

 

 

Authority: Associated Publications

Associated publication (RG)

shares the table name assocpublicationgroup

shares the table name collectionobjects_mmi

Y

 

 

 

Associated publication (URN)

  .assocpublication

  :assocPublicationList/*/assocPublication

 

 

 

 

 

Associated publication type (CL)

  .assocpublicationtype

  :assocPublicationList/*/assocPublicationType

 

 

 

 

 

Associated publication note

  .assocpublicationnote

  :assocPublicationList/*/assocPublicationNote

 

 

 

 

Authority: Production Entities

Production organization (RG)

shares the table name objectproductionorganizationgroup

shares the table name collectionobjects_common

Y

 

 

 

Production organization (URN)

  .objectproductionorganization

  :objectProductionOrganizationGroupList/*/objectProductionOrganization

 

 

 

 

 

Production role (CL)

  .objectproductionorganizationrole

  :objectProductionOrganizationGroupList/*/objectProductionOrganizationRole

 

 

 

 

Authority: Content Entities

Content organization (RG)

shares the table name
contententitygroup

shares the table name
collectionobjects_mmi

Y

 

 

 

 

Content entity (URN)

  .contententity

  :contentEntityList/*/contentEntity

 

 

 

 

 

Content entity type (CL)

  .contententitytype

  :contentEntityList/*/contentEntityType

 

 

 

 

 

Content entity note

  .contententitynote

  :contentEntityList/*/contentEntityNote

 

 

 

Authority: Content Works

Content works (RG)

shares the table name
contentworkgroup

shares the table name
collectionobjects_mmi

Y

 

 

 

Content work (URN)

  .contentwork

  :contentWorkList/*/contentWork

 

 

 

 

Content work type (CL)

  .contentworktype

  :contentWorkList/*/contentWorkType

 

 

 

 

Content work note

  .contentworknote

  :contentWorkList/*/contentWorkNote

 

 

 

Authority: Object Production Entities

Object Production Entity (RG)

shares the table name
objprodentitygroup

shares the table name
collectionobjects_mmi

Y

 

 

 

Object production entity (URN)

  .objprodentity

  :objProdEntityList/*/objProdEntity

 

 

 

 

Object production entity type (CL)

  .objprodentitytype

  :objProdEntityList/*/objProdEntityType

 

 

 

 

Object production entity note

  .objprodentitynote

  :objProdEntityList/*/objProdEntityNote

 

 

 

Authority: Groups (collection subsets)

need to add

 

 

Y

 

 

Acquisition

Credit line

Credit Line

acquisitions_common.creditline

 

N

 

 

Location

Current location

Current location (URN)

movements_common.currentlocation

movements_common:currentLocation

N

 

 

...


The fields marked (RF) describe the NXQL format that will search through all elements of that repeatable field. To limit the search to the primary value then append /0 to the field name, e.g. collectionobjects_mmi:mmiTechniques/0

...

Finding related procedural records using the Relationship service

The relations service provides the mechanism to find related procedural records of a given type. The syntax for this service API uses subject and object query parameters to denote the relationship direction.

...

/wiki/spaces/collectionspace/pages/666273449
CollecitonObject RESTful API
Common services RESTful API
Media service RESTful API
Relation service RESTful API