Tester et paramétrer les requêtes RGD

[tfrancart]

RGD = type de document "Réglement Grand Ducal"

Requête pour avoir le nbr de RGD sans projet en 2024

PREFIX jolux: http://data.legilux.public.lu/resource/ontology/jolux#
SELECT (count(?rgd) AS ?nb)
WHERE {
?memorial a jolux:Memorial;
jolux:memorialYear ?memYear;
jolux:memorialNumber ?memorialNumber;
jolux:publicationDate ?publicationDate;
jolux:isMemberOf ?memorialSerial .
?act a jolux:Act .
?act jolux:isPartOf ?memorial .
?act jolux:typeDocument ?typeDocument .

BIND("rgd" AS ?rgd)
FILTER(?memYear=2024)
FILTER(STR(?typeDocument)='http://data.legilux.public.lu/resource/authority/resource-type/RGD')
FILTER(NOT EXISTS{?act jolux:draft ?draft})
} GROUP BY ?rgd

Requête pour avoir le nbr de RGD avec projet en 2024

PREFIX jolux: http://data.legilux.public.lu/resource/ontology/jolux#
SELECT (count(?rgd) AS ?nb)
WHERE {
?memorial a jolux:Memorial;
jolux:memorialYear ?memYear;
jolux:memorialNumber ?memorialNumber;
jolux:publicationDate ?publicationDate;
jolux:isMemberOf ?memorialSerial .
?act a jolux:Act .
?act jolux:isPartOf ?memorial .
?act jolux:typeDocument ?typeDocument .

BIND("rgd" AS ?rgd)
FILTER(?memYear=2024)
FILTER(STR(?typeDocument)='http://data.legilux.public.lu/resource/authority/resource-type/RGD')
FILTER(EXISTS{?act jolux:draft ?draft})
} GROUP BY ?rgd

Requête pour avoir la liste des RGD sans projet en 2024

PREFIX jolux: http://data.legilux.public.lu/resource/ontology/jolux#
SELECT *
WHERE {
?memorial a jolux:Memorial;
jolux:memorialYear ?memYear;
jolux:memorialNumber ?memorialNumber;
jolux:publicationDate ?publicationDate;
jolux:isMemberOf ?memorialSerial .
?act a jolux:Act .
?act jolux:isPartOf ?memorial .
?act jolux:typeDocument ?typeDocument .

FILTER(?memYear=2024)
FILTER(STR(?typeDocument)='http://data.legilux.public.lu/resource/authority/resource-type/RGD')
FILTER(NOT EXISTS{?act jolux:draft ?draft})
} ORDER BY ?memorialNumber

Requête pour avoir la liste des RGD avec projet en 2024

PREFIX jolux: http://data.legilux.public.lu/resource/ontology/jolux#
SELECT *
WHERE {
?memorial a jolux:Memorial;
jolux:memorialYear ?memYear;
jolux:memorialNumber ?memorialNumber;
jolux:publicationDate ?publicationDate;
jolux:isMemberOf ?memorialSerial .
?act a jolux:Act .
?act jolux:isPartOf ?memorial .
?act jolux:typeDocument ?typeDocument .

FILTER(?memYear=2024)
FILTER(STR(?typeDocument)='http://data.legilux.public.lu/resource/authority/resource-type/RGD')
FILTER(EXISTS{?act jolux:draft ?draft})
} ORDER BY ?memorialNumber