Skip to content

Data of old forms and eForms is not harmonized leading to partial results #56

@Anoop-Variyan

Description

@Anoop-Variyan

Currently, the data of old forms and eForms is not harmonized. So, users have no clue that when they execute the queries they are receiving partial output for most of the queries in the query library or own queries, especially for those publication dates when old forms were still active.
Therefore, old forms should be reprocessed and should be made available in the same named graphs as the eForms.

Below combined query can be used to check in whole and in also parts.

PREFIX epo: http://data.europa.eu/a4g/ontology#
PREFIX xsd: http://www.w3.org/2001/XMLSchema#

SELECT ?eformsCount ?oldFormCount (?eformsCount + ?oldFormCount as ?totalCount)
WHERE {
{
SELECT (COUNT(DISTINCT ?publicationNumber) AS ?eformsCount)
WHERE {
GRAPH ?g {
?notice a epo:Notice ;
epo:hasPublicationDate ?publicationDate ;
epo:hasNoticePublicationNumber ?publicationNumber .
}
FILTER (?publicationDate = "2023-10-04"^^xsd:date )
}
}
{
SELECT (COUNT(distinct ?notice) AS ?oldFormCount)
WHERE {
GRAPH ?g {
?notice a epo:Notice ;
epo:hasPublicationDate ?publicationDate .
}
FILTER(STR(?publicationDate) = "20231004" )
}
}
}

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions