Dreams:report-index: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== Rapporter == | |||
{{SPARQL | query= | {{SPARQL | query= | ||
PREFIX target: <https://dreams.wikibase.cloud/entity/Q158> | |||
PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | ||
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> | PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> | ||
PREFIX dreamsp: <https://dreams.wikibase.cloud/prop/> | |||
PREFIX dreamspsv: <https://dreams.wikibase.cloud/prop/statement/value/> | |||
SELECT | SELECT | ||
? | ?udgivelsesdato | ||
? | ?titel ?titelUrl | ||
?miljøportal ?miljøportalUrl | |||
? | |||
WHERE { | WHERE { | ||
?report dreamst:P2 / dreamst:P10* dreams:Q8 . | ?report dreamst:P2 / dreamst:P10* dreams:Q8 . | ||
OPTIONAL { | OPTIONAL { | ||
?report dreamst:P1 ? | ?report dreamst:P1 ?titel . | ||
BIND(CONCAT("#report/", SUBSTR(STR(?report), 38)) AS ?titelUrl) | |||
} | } | ||
OPTIONAL { | OPTIONAL { | ||
?report | ?report dreamsp:P6 / dreamspsv:P6 ?udgivelsesdato_value . | ||
?udgivelsesdato_value wikibase:timePrecision ?time_precision ; | |||
wikibase:timeValue ?udgivelsesdato_ . | |||
BIND(IF(?time_precision = 9, YEAR(?udgivelsesdato_), xsd:date(?udgivelsesdato_)) AS ?udgivelsesdato) | |||
} | } | ||
OPTIONAL { | OPTIONAL { | ||
?report dreamst:P40 ? | ?report dreamst:P40 ?miljøportal . | ||
BIND(IRI(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", | BIND(IRI(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", ?miljøportal)) AS ?miljøportalUrl) | ||
} | } | ||
} | } | ||
ORDER BY DESC(? | ORDER BY DESC(?udgivelsesdato) | ||
}} | }} | ||
Latest revision as of 14:10, 9 December 2022
Rapporter
PREFIX target: <https://dreams.wikibase.cloud/entity/Q158> PREFIX dreams: <https://dreams.wikibase.cloud/entity/> PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> PREFIX dreamsp: <https://dreams.wikibase.cloud/prop/> PREFIX dreamspsv: <https://dreams.wikibase.cloud/prop/statement/value/> SELECT ?udgivelsesdato ?titel ?titelUrl ?miljøportal ?miljøportalUrl WHERE { ?report dreamst:P2 / dreamst:P10* dreams:Q8 . OPTIONAL { ?report dreamst:P1 ?titel . BIND(CONCAT("#report/", SUBSTR(STR(?report), 38)) AS ?titelUrl) } OPTIONAL { ?report dreamsp:P6 / dreamspsv:P6 ?udgivelsesdato_value . ?udgivelsesdato_value wikibase:timePrecision ?time_precision ; wikibase:timeValue ?udgivelsesdato_ . BIND(IF(?time_precision = 9, YEAR(?udgivelsesdato_), xsd:date(?udgivelsesdato_)) AS ?udgivelsesdato) } OPTIONAL { ?report dreamst:P40 ?miljøportal . BIND(IRI(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", ?miljøportal)) AS ?miljøportalUrl) } } ORDER BY DESC(?udgivelsesdato)