Revision 52192
Added by Claudio Atzori almost 6 years ago
| modules/dnet-openaireplus-workflows/branches/6.1.9-patchDirectIndexing/src/main/resources/eu/dnetlib/patch-db/materialised_views.sql | ||
|---|---|---|
| 217 | 217 |
pac.code || '@@@' || pac.name || '@@@' || pas.code || '@@@' || pas.name AS provenanceaction, |
| 218 | 218 |
array_agg(DISTINCT i.pid || '###' || i.issuertypeclass) AS pid, |
| 219 | 219 |
array_agg(DISTINCT s.name || '###' || sc.code || '@@@' || sc.name || '@@@' || ss.code || '@@@' || ss.name) AS subjects, |
| 220 |
array_agg(fp.path) AS fundingtree
|
|
| 220 |
array_agg(DISTINCT fp.path) AS fundingtree
|
|
| 221 | 221 |
FROM projects p |
| 222 | 222 |
LEFT OUTER JOIN class cc ON (cc.code = p.contracttypeclass) |
| 223 | 223 |
LEFT OUTER JOIN scheme cs ON (cs.code = p.contracttypescheme) |
Also available in: Unified diff
distinct fundingpaths in projects_mv