SUNScholar/SQL Tips
Jump to navigation
Jump to search
Back to System Admin
Below are SQL statements to be used for various purposes.
- Extract metadata
SELECT * FROM metadatavalue WHERE metadata_field_id = ( SELECT metadata_field_id FROM metadatafieldregistry WHERE element = 'date' AND qualifier = 'issused' ) SELECT * FROM metadatavalue WHERE metadata_field_id = ( SELECT metadata_field_id FROM metadatafieldregistry WHERE element = 'contributor' AND qualifier = 'advisor' )
