Revision 61866
Added by Michele Artini over 2 years ago
| modules/dnet-openaire-datasource-manager/branches/dismiss_repo_profiles/src/main/resources/eu/dnetlib/enabling/datasources/queries/listApisByDsId.sql | ||
|---|---|---|
| 2 | 2 |
a.id AS "id", |
| 3 | 3 |
a.protocol AS "protocol", |
| 4 | 4 |
a.baseurl AS "baseUrl", |
| 5 |
a.datasource AS "datasource",
|
|
| 5 |
a.service AS "datasource",
|
|
| 6 | 6 |
a.contentdescription AS "contentdescription", |
| 7 | 7 |
a.active AS "active", |
| 8 | 8 |
a.removable AS "removable", |
| ... | ... | |
| 25 | 25 |
dsm_api a |
| 26 | 26 |
LEFT OUTER JOIN dsm_apiparams p on (a.id = p.api) |
| 27 | 27 |
WHERE |
| 28 |
a.datasource = :dsId
|
|
| 28 |
a.service = :dsId
|
|
| 29 | 29 |
GROUP BY |
| 30 | 30 |
a.id, |
| 31 | 31 |
a.protocol, |
| 32 | 32 |
a.baseurl, |
| 33 |
a.datasource,
|
|
| 33 |
a.service,
|
|
| 34 | 34 |
a.contentdescription, |
| 35 | 35 |
a.active, |
| 36 | 36 |
a.removable, |
Also available in: Unified diff