dnet45/modules/dnet-openaire-datasource-manager/trunk/src/main/resources/eu/dnetlib/enabling/datasources/queries/searchDsByType.sql @ 50278
| 1 |
SELECT
|
|---|---|
| 2 |
ds.id AS id, |
| 3 |
ds.officialname AS name, |
| 4 |
ds.typology AS typology, |
| 5 |
array_agg(a.id) AS apis |
| 6 |
FROM
|
| 7 |
dsm_datasources ds |
| 8 |
LEFT OUTER JOIN dsm_api a ON (ds.id = a.datasource) |
| 9 |
WHERE
|
| 10 |
ds.typology = :type |
| 11 |
GROUP BY |
| 12 |
ds.id, ds.officialname, ds.typology |
| 13 |
ORDER BY |
| 14 |
ds.officialname |