Page History
...
Column names like item_id
or community_id
have been mostly replaced with the tuple (resource_id
, resource_type_id
) where resource_type_id is a constant specifying object type:
constant | object type |
---|---|
0 | bitstream |
1 | bundle |
2 | item |
3 | collection |
4 | community |
5 | site |
6 | group |
7 | eperson |
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT text_value FROM metadatavalue
JOIN handle as h ON h.resource_id = metadatavalue.dspace_object_id
WHERE metadata_field_id = (
SELECT metadata_field_id
FROM metadatafieldregistry mfr, metadataschemaregistry msr
WHERE mfr.metadata_schema_id = msr.metadata_schema_id
AND short_id = 'dc'
AND element = 'title'
AND qualifier IS NULL
)
AND resource_type_id=2; |
...
Example eperson
table in DSpace 4 (simplified to show only relevant parts):
eperson_id | firstname | lastname |
---|---|---|
1001 | John | Smith |
1002 | Jane | Doe |
Example eperson
and metadatavalue
tables in DSpace 5 (simplified to show only relevant parts):
eperson
:
eperson_id |
---|
1001 |
1002 |
metadatavalue
:
resource_type_id | resource_id | metadata_field_id | text_value |
---|---|---|---|
7 | 1001 | 123 | John |
7 | 1001 | 124 | Smith |
7 | 1002 | 123 | Jane |
7 | 1002 | 124 | Doe |
See also
Jira | ||||||
---|---|---|---|---|---|---|
|
...
Overview
Content Tools