dnet45/modules/dnet-openaire-datasource-manager/trunk/src/main/resources/eu/dnetlib/enabling/datasources/queries/searchDsByType.sql @ 51943
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 |