Revision 56999
Added by Alessia Bardi over 4 years ago
modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/hbase/queryDatasources.sql | ||
---|---|---|
36 | 36 |
END AS openairecompatibility, |
37 | 37 |
d.websiteurl AS websiteurl, |
38 | 38 |
d.logourl AS logourl, |
39 |
array_agg(DISTINCT CASE WHEN a.protocol = 'oai' THEN a.baseurl ELSE NULL END) AS accessinfopackage, |
|
39 |
array_agg(DISTINCT CASE WHEN a.protocol = 'oai' and last_aggregation_date is not null THEN a.baseurl ELSE NULL END) AS accessinfopackage,
|
|
40 | 40 |
d.latitude AS latitude, |
41 | 41 |
d.longitude AS longitude, |
42 | 42 |
d.namespaceprefix AS namespaceprefix, |
Also available in: Unified diff
fixes #4865: do not export OAI PMH URLs that are not used