Revision 62962
Added by Michele Artini 10 months ago
| searchApisUsingField.sql | ||
|---|---|---|
| 5 | 5 |
a.active AS "active", |
| 6 | 6 |
a.baseurl AS "baseUrl", |
| 7 | 7 |
ds.eosc_datasource_type AS "type", |
| 8 |
coalesce(a.last_aggregation_date::text, '') AS "aggrDate",
|
|
| 8 |
a.last_aggregation_date AS "aggrDate",
|
|
| 9 | 9 |
coalesce(a.last_aggregation_total, 0) AS "aggrTotal", |
| 10 | 10 |
coalesce(a.last_aggregation_mdid, '') AS "aggrMdId", |
| 11 |
coalesce(a.last_collection_date::text, '') AS "collDate",
|
|
| 11 |
a.last_collection_date AS "collDate",
|
|
| 12 | 12 |
coalesce(a.last_collection_total, 0) AS "collTotal", |
| 13 | 13 |
coalesce(a.last_collection_mdid, '') AS "collMdId", |
| 14 | 14 |
ds.id AS "dsId", |
Also available in: Unified diff
fixed a problem with dates