02-01-2013 12:46 PM
select d.*, o.* from mis:museumRecord as d join mis:recordable as o on d.cmis:objectId = o.cmis:objectId
<aspect name="mis:recordable">
<title>Recordable</title>
<parent>cm:generalclassifiable</parent>
<properties>
<property name="mis:sisn">
<type>d:text</type>
<index enabled="true">
<atomic>true</atomic>
<stored>true</stored>
<tokenised>true</tokenised>
</index>
</property>
<property name="mis:extent">
<type>d:text</type>
<multiple>true</multiple>
<index enabled="true">
<atomic>true</atomic>
<stored>true</stored>
<tokenised>true</tokenised>
</index>
</property>
<property name="mis:accessionNumber">
<type>d:text</type>
<multiple>true</multiple>
<index enabled="true">
<atomic>true</atomic>
<stored>true</stored>
<tokenised>true</tokenised>
</index>
</property>
</properties>
<associations>
<association name="mis:creator">
<source>
<mandatory>false</mandatory>
<many>true</many>
</source>
<target>
<class>mis:person</class>
<mandatory>false</mandatory>
<many>true</many>
</target>
</association>
</associations>
</aspect>
<type name="mis:museumRecord">
<title>Museum Record</title>
<parent>cm:content</parent>
<properties>
</properties>
<mandatory-aspects>
<aspect>cm:titled</aspect>
<aspect>mis:recordable</aspect>
</mandatory-aspects>
</type>
02-01-2013 05:55 PM
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.