WORKSHOP_BIOSAMPLECOLLECTION_PROJECT_IDENTIFIER

display.xml

	<DisplayField id="WORKSHOP_BIOSAMPLECOLLECTION_PROJECT_IDENTIFIER" header="WORKSHOP_BIOSAMPLECOLLECTION ID" visible="true" searchable="false" data-type="string" xsi:type="SubQueryField">
		<Content type="sql">workshop_biosamplecollection_project_id</Content>
		<HTML-Link>
			<SecureLink elementName="workshop:biosampleCollection">
				<securityMappingValue displayFieldId="PROJECTS" schemaElementMap="workshop:biosampleCollection/sharing/share/project"/>
				<securityMappingValue displayFieldId="PROJECT" schemaElementMap="workshop:biosampleCollection/project"/>
			</SecureLink>
			<Property name="HREF" value="@WEBAPPapp/action/DisplayItemAction/search_value/@Field1/search_element/workshop:biosampleCollection/search_field/workshop:biosampleCollection.ID/project/@Field2">
				<InsertValue id="Field1" field="EXPT_ID"/>
				<InsertValue id="Field2" field="@WHERE"/>
			</Property>
		</HTML-Link>
		<SubQuery>SELECT DISTINCT COALESCE(label,sharing_share_xnat_experimentda_id) AS workshop_biosamplecollection_project_id,sharing_share_xnat_experimentda_id FROM (	SELECT sharing_share_xnat_experimentda_id,label FROM xnat_experimentdata_share WHERE project='@WHERE'	UNION 	SELECT id,label FROM xnat_experimentData WHERE project='@WHERE' )SEARCH</SubQuery>
		<MappingColumns>
			<MappingColumn schemaField="workshop:biosampleCollection.ID" queryField="sharing_share_xnat_experimentda_id"/>
		</MappingColumns>
	</DisplayField>