Revision 29118
Added by Michele Artini about 10 years ago
| modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/hbase/queryDatasources.sql | ||
|---|---|---|
| 4 | 4 |
d.websiteurl as websiteurl, |
| 5 | 5 |
d.logourl as logourl, |
| 6 | 6 |
d.contactemail as contactemail, |
| 7 |
array_agg(DISTINCT CASE WHEN COALESCE(apc.edited, '') = '' THEN apc.edited ELSE apc.original END) as accessinfopackage,
|
|
| 7 |
array_agg(DISTINCT CASE WHEN COALESCE(apc.edited, '') = '' THEN apc.original ELSE apc.edited END) as accessinfopackage,
|
|
| 8 | 8 |
d.latitude as latitude, |
| 9 | 9 |
d.longitude as longitude, |
| 10 | 10 |
d.namespaceprefix as namespaceprefix, |
Also available in: Unified diff
fixed a return value