Dreams:effect: Difference between revisions

Dreams:effect (view source)

Revision as of 21:10, 13 October 2022

731 bytes added , 1 year ago

→‎Affects

Fnielsen

Bureaucrats, Administrators

16,603

edits

@@ Line 75: / Line 75: @@
 == Affects ==
 {{SPARQL | query=
-PREFIX target: <https://dreams.wikibase.cloud/entity/Q6>
+PREFIX target: <https://dreams.wikibase.cloud/entity/Q309>
 PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
 PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
@@ Line 101: / Line 102: @@
    (CONCAT("#report/", SUBSTR(STR(?report), 38)) AS ?reportUrl)
+  ?link ?linkUrl
 WHERE {
    ?pattern dreamst:P2 dreams:Q263 ;
@@ Line 106: / Line 108: @@
    OPTIONAL { ?pattern dreamst:P34 ?affected . }
    OPTIONAL { ?pattern dreamst:P18 ?quote . }
-   OPTIONAL { ?pattern dreamst:P20 ?report . }
+   OPTIONAL {
+    ?pattern dreamst:P20 ?report .
+    OPTIONAL {
+      ?report dreamst:P40 ?miljøportal .
+      BIND("↗" AS ?link1)
+      BIND(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", STR(?miljøportal)) AS ?link1Url)
+      OPTIONAL {
+        ?pattern dreamst:P46 ?page .
+        BIND(CONCAT(?page, "&nbsp;↗") AS ?link2)
+        BIND(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", STR(?miljøportal),
+                  "#page=", ?page) AS ?link2Url)
+      }
+      # This doesn't not make sense
+      BIND(COALESCE(?link2, ?link1) AS ?link)
+      # BIND(COALESCE(?link2Url, ?link1Url) AS ?linkUrl)
+      BIND(IF(EXISTS { ?pattern dreamst:P46 ?page }, ?link2Url, ?link1Url) AS ?linkUrl)
+    }
+  }
    OPTIONAL { ?pattern dreamst:P21 / dreamst:P44 ?symbol . }