Revision 62939
Added by Michele Artini 11 months ago
| searchApisUsingField.sql | ||
|---|---|---|
| 7 | 7 |
ds.eosc_datasource_type AS "type", |
| 8 | 8 |
coalesce(a.last_aggregation_date::text, a.last_download_date::text, '') AS "aggrDate", |
| 9 | 9 |
coalesce(a.last_aggregation_total, a.last_download_total, 0) AS "aggrTotal", |
| 10 |
coalesce(a.last_aggregation_mdid, a.last_download_objid, '') AS "aggrMdId", |
|
| 11 |
coalesce(a.last_collection_date::text, '') AS "collDate", |
|
| 12 |
coalesce(a.last_collection_total, 0) AS "collTotal", |
|
| 13 |
coalesce(a.last_collection_mdid, '') AS "collMdId", |
|
| 10 | 14 |
ds.id AS "dsId", |
| 11 | 15 |
ds.officialname AS "name", |
| 12 | 16 |
ds.englishname AS "alternativeName", |
| ... | ... | |
| 29 | 33 |
a.active, |
| 30 | 34 |
a.last_aggregation_date, |
| 31 | 35 |
a.last_download_date, |
| 36 |
a.last_collection_date, |
|
| 32 | 37 |
a.last_aggregation_total, |
| 33 | 38 |
a.last_download_total, |
| 39 |
a.last_collection_total, |
|
| 40 |
a.last_aggregation_mdid, |
|
| 41 |
a.last_download_objid, |
|
| 42 |
a.last_collection_mdid, |
|
| 34 | 43 |
ds.id, |
| 35 | 44 |
ds.officialname, |
| 36 | 45 |
ds.englishname, |
Also available in: Unified diff
added new fields in search response