|
1
|
SELECT
|
|
2
|
ds.id AS "id",
|
|
3
|
ds.officialname AS "officialname",
|
|
4
|
ds.englishname AS "englishname",
|
|
5
|
ds.websiteurl AS "websiteurl",
|
|
6
|
ds.logourl AS "logourl",
|
|
7
|
ds.contactemail AS "contactemail",
|
|
8
|
ds.latitude AS "latitude",
|
|
9
|
ds.longitude AS "longitude",
|
|
10
|
ds.timezone AS "timezone",
|
|
11
|
ds.namespaceprefix AS "namespaceprefix",
|
|
12
|
ds.languages AS "languages",
|
|
13
|
ds.od_contenttypes AS "od_contenttypes",
|
|
14
|
ds.collectedfrom AS "collectedfrom",
|
|
15
|
ds.dateofvalidation AS "dateofvalidation",
|
|
16
|
ds.typology AS "typology",
|
|
17
|
ds.provenanceaction AS "provenanceaction",
|
|
18
|
ds.dateofcollection AS "dateofcollection",
|
|
19
|
ds.platform AS "platform",
|
|
20
|
ds.activationid AS "activationId",
|
|
21
|
ds.description AS "description",
|
|
22
|
ds.releasestartdate AS "releasestartdate",
|
|
23
|
ds.releaseenddate AS "releaseenddate",
|
|
24
|
ds.missionstatementurl AS "missionstatementurl",
|
|
25
|
ds.dataprovider AS "dataprovider",
|
|
26
|
ds.serviceprovider AS "serviceprovider",
|
|
27
|
ds.databaseaccesstype AS "databaseaccesstype",
|
|
28
|
ds.datauploadtype AS "datauploadtype",
|
|
29
|
ds.databaseaccessrestriction AS "databaseaccessrestriction",
|
|
30
|
ds.datauploadrestriction AS "datauploadrestriction",
|
|
31
|
ds.versioning AS "versioning",
|
|
32
|
ds.citationguidelineurl AS "citationguidelineurl",
|
|
33
|
ds.qualitymanagementkind AS "qualitymanagementkind",
|
|
34
|
ds.pidsystems AS "pidsystems",
|
|
35
|
ds.certificates AS "certificates",
|
|
36
|
ds.aggregator AS "aggregator",
|
|
37
|
ds.issn AS "issn",
|
|
38
|
ds.eissn AS "eissn",
|
|
39
|
ds.lissn AS "lissn",
|
|
40
|
ds.registeredby AS "registeredby",
|
|
41
|
ds.subjects AS "subjects",
|
|
42
|
ds.managed AS "managed"
|
|
43
|
FROM
|
|
44
|
dsm_datasources ds
|
|
45
|
WHERE
|
|
46
|
ds.id = :dsId
|
|
47
|
|
|
48
|
|
|
49
|
|