Revision 55878
Added by Alessia Bardi almost 5 years ago
queryDatasources.sql | ||
---|---|---|
103 | 103 |
WHEN (d.typology = 'orprepository') THEN 'Repository' |
104 | 104 |
ELSE 'Other' |
105 | 105 |
END || '@@@dnet:datasource_typologies@@@dnet:datasource_typologies' AS datasourcetype, |
106 |
'sysimport:crosswalk:entityregistry@@@sysimport:crosswalk:entityregistry@@@dnet:provenance_actions@@@dnet:provenance_actions' AS provenanceaction |
|
106 |
'sysimport:crosswalk:entityregistry@@@sysimport:crosswalk:entityregistry@@@dnet:provenance_actions@@@dnet:provenance_actions' AS provenanceaction, |
|
107 |
CONCAT(d.issn, '@@@', d.eissn, '@@@', d.lissn) AS journal |
|
107 | 108 |
|
108 | 109 |
FROM dsm_datasources d |
109 | 110 |
|
... | ... | |
139 | 140 |
d.pidsystems, |
140 | 141 |
d.certificates, |
141 | 142 |
dc.id, |
142 |
dc.officialname |
|
143 |
dc.officialname, |
|
144 |
d.issn, |
|
145 |
d.eissn, |
|
146 |
d.lissn |
Also available in: Unified diff
get journal fields from the database