Revision 61861
Added by Michele Artini over 2 years ago
| searchDsByType.sql | ||
|---|---|---|
| 4 | 4 |
ds.typology AS typology, |
| 5 | 5 |
array_agg(a.id) AS apis |
| 6 | 6 |
FROM |
| 7 |
dsm_datasources ds
|
|
| 8 |
LEFT OUTER JOIN dsm_api a ON (ds.id = a.datasource)
|
|
| 7 |
dsm_services ds
|
|
| 8 |
LEFT OUTER JOIN dsm_api a ON (ds.id = a.service)
|
|
| 9 | 9 |
WHERE |
| 10 | 10 |
ds.typology = :type |
| 11 | 11 |
GROUP BY |
Also available in: Unified diff
new dsm_services table