Re: [dspace-tech] Query for DSpace's 5.5 database

2016-12-14 Thread Mariangels
Thanks, Helix. El dilluns, 12 desembre de 2016 17:22:45 UTC+1, helix84 va escriure: > > Start with this: > > SELECT text_value AS dc_date_accessionedFROM metadatavalueWHERE > metadata_field_id = ( > SELECT metadata_field_id > FROM metadatafieldregistry, metadataschemaregistry > WHERE

Re: [dspace-tech] Query for DSpace's 5.5 database

2016-12-12 Thread helix84
Start with this: SELECT text_value AS dc_date_accessionedFROM metadatavalueWHERE metadata_field_id = ( SELECT metadata_field_id FROM metadatafieldregistry, metadataschemaregistry WHERE metadatafieldregistry.metadata_schema_id = metadataschemaregistry.metadata_schema_id AND short_id = 'dc'

[dspace-tech] Query for DSpace's 5.5 database

2016-12-12 Thread Mariangels
Hello, We are working with DSpace 5.5. We need a total report (all our records) from the DSpace's database showing all those fields: dc.date.accesioned dc.rights.accesRights dc.type dc.identifier.uri and the main community How can I ask the database for get this information? Thaks in advance.