Page History
...
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
...
Overview
Content Tools