Project

General

Profile

« Previous | Next » 

Revision 56999

fixes #4865: do not export OAI PMH URLs that are not used

View differences:

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