Number of institutional datasources for PROVIDE dropped to zero
#8
Closed
opened 2 years ago by claudio.atzori
·
1 comments
Loading…
Reference in New Issue
There is no content yet.
Delete Branch '%!s(<nil>)'
Deleting a branch is permanent. It CANNOT be undone. Continue?
Originally reported in https://support.openaire.eu/issues/8055
The exporter application implements a method used by the KPI reporting system to acquire the number of publication institutional repositories from which OpenAIR aggregates bibliographic records. This method is exposed on the path
GET /openaire/ds/countregistered
and the number is obtained with a request like the following:
curl -X GET "http://services.openaire.eu/openaire/ds/countregistered?fromDate=2021-01-01&typologyFilter=pubsrepository%3A%3Ainstitutional" -H "accept: application/json"
Since the update to support the EOSC model was introduced, the number reported dropped to zero, and checking the queries to the DB I stumbled on the following query template
7a83fb8c67/apps/dnet-exporter-api/src/main/resources/eu/dnetlib/openaire/sql/recent_registered_datasources_fromDate_typology.st.sql (L9)
Which applies the filter on the
eosc_datasource_type
column. Shouldn't it use the_typology_to_remove_
column instead? I remember we kept it for backward compatibilityI updated the sql query replacing the field
eosc_datasource_type
with_typology_to_remove_