16,603
edits
Dreams:report: Difference between revisions
→Patterns: Add mitigation
(→Patterns: Project type from report) |
(→Patterns: Add mitigation) |
||
| Line 86: | Line 86: | ||
== Patterns == | == Patterns == | ||
{{SPARQL | query= | {{SPARQL | query= | ||
PREFIX target: <https://dreams.wikibase.cloud/entity/Q406> | |||
PREFIX target: <https://dreams.wikibase.cloud/entity/ | |||
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/> | ||
| Line 106: | Line 105: | ||
?quote | ?quote | ||
?mitigation ?mitigationLabel ?mitigationUrl | |||
?project_phase ?project_phaseLabel | ?project_phase ?project_phaseLabel | ||
| Line 128: | Line 129: | ||
WHERE { | WHERE { | ||
?pattern dreamst:P2 dreams:Q263 ; | ?pattern dreamst:P2 dreams:Q263 ; | ||
dreamst:P20 target: . | |||
OPTIONAL { | OPTIONAL { | ||
| Line 161: | Line 162: | ||
OPTIONAL { ?pattern dreamst:P18 ?quote . } | OPTIONAL { ?pattern dreamst:P18 ?quote . } | ||
OPTIONAL { | |||
?pattern dreamst:P56 ?mitigation . | |||
?mitigation rdfs:label ?mitigation_label . | |||
FILTER (LANG(?mitigation_label) = 'da') | |||
BIND(CONCAT("#effect/", SUBSTR(STR(?mitigation), 38)) AS ?mitigationUrl) | |||
} | |||
OPTIONAL { ?pattern dreamst:P53 ?recipient_text } | |||
BIND(COALESCE(?recipient, ?recipient_text) AS ?recipient) | |||
BIND(CONCAT(COALESCE(?recipient_label, ""), ' (', ?recipient_text, ')') AS ?recipientLabel) | |||
OPTIONAL { ?pattern dreamst:P19 ?project_phase . } | OPTIONAL { ?pattern dreamst:P19 ?project_phase . } | ||