Revision 62012
Added by Michele Artini about 2 years ago
| searchApisNormal.sql | ||
|---|---|---|
| 12 | 12 |
ds.namespaceprefix AS "prefix", |
| 13 | 13 |
ds.websiteurl AS "websiteUrl", |
| 14 | 14 |
coalesce((array_agg(o.country))[1], '-') AS "country", |
| 15 |
(array_agg(o.legalname))[1] AS "organization" |
|
| 15 |
(array_agg(o.legalname))[1] AS "organization", |
|
| 16 |
ds.consenttermsofuse AS "consenttermsofuse", |
|
| 17 |
ds.fulltextdownload AS "fulltextdownload" |
|
| 16 | 18 |
FROM dsm_api a |
| 17 | 19 |
LEFT OUTER JOIN dsm_services ds ON (a.service = ds.id) |
| 18 | 20 |
LEFT OUTER JOIN dsm_service_organization dsorg ON (ds.id = dsorg.service) |
| ... | ... | |
| 41 | 43 |
ds.officialname, |
| 42 | 44 |
ds.englishname, |
| 43 | 45 |
ds.namespaceprefix, |
| 44 |
ds.websiteurl |
|
| 45 |
|
|
| 46 |
|
|
| 46 |
ds.websiteurl, |
|
| 47 |
ds.consenttermsofuse, |
|
| 48 |
ds.fulltextdownload |
|
Also available in: Unified diff
new fields in repo ui: fulltextdownload and consenttermsofuse