...
The metadatavalue
table is an important table in DSpace because it holds the metadata values of DSpace objects (ie. article title, authors, identifiers). The table uses the so-called EAV (Entity-attribute-value) model as further explained in this article.
...
Code Block | ||
---|---|---|
| ||
SELECT text_value FROM metadatavalue WHERE metadata_field_id = ds6_metadata_field2id('contributor', 'author') AND dspace_object_id='f2cf9909-0357-4037-8305-4a426bf9a826'; |
Example
The following query selects the titles and handles of collections whose titles end with "Research".
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT metadatavalue.text_value, handle.handle
FROM collection
INNER JOIN metadatavalue ON collection.uuid = metadatavalue.dspace_object_id
INNER JOIN handle ON collection.uuid = handle.resource_id
WHERE metadatavalue.metadata_field_id = 64
AND metadatavalue.text_value LIKE '%Research'; |
See also
- Metadata for all DSpace objects
- Storage Layer#RDBMS/DatabaseStructure
- Metadata and Bitstream Format Registries
- Helper SQL functions for DSpace 6
...