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 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 likeLIKE '%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