Difference between revisions of "SUNScholar/SQL Tips"
Jump to navigation
Jump to search
(Created page with "<center> '''Back to System Admin''' </center> Below are SQL statements to be used for various purposes.") |
m |
||
| Line 4: | Line 4: | ||
Below are SQL statements to be used for various purposes. | 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' ) | ||
Revision as of 15:44, 22 September 2014
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' )
