Number of institutional datasources for PROVIDE dropped to zero #8

Closed
opened 2 years ago by claudio.atzori · 1 comments
Owner

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 compatibility

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 https://code-repo.d4science.org/D-Net/dnet-applications/src/commit/7a83fb8c6779ecddd8e0d1175349e7ffe09a9873/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 compatibility
michele.artini was assigned by claudio.atzori 2 years ago
Collaborator

I updated the sql query replacing the field eosc_datasource_type with _typology_to_remove_

I updated the sql query replacing the field `eosc_datasource_type` with `_typology_to_remove_`
michele.artini closed this issue 2 years ago
Sign in to join this conversation.
No Label
No Milestone
No Assignees
2 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: D-Net/dnet-applications#8
Loading…
There is no content yet.