Dreams:effect: Difference between revisions

Line 173: Line 173:
   }
   }


  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}
}}
== Er påvirket af ==
{{SPARQL | query=
PREFIX target: <https://dreams.wikibase.cloud/entity/Q6>
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
  ?pattern ?patternLabel
  (CONCAT("#pattern/", SUBSTR(STR(?pattern), 38)) AS ?patternUrl) 
  ?effect ?effectLabel
  (CONCAT("#effect/", SUBSTR(STR(?effect), 38)) AS ?effectUrl) 
  ?significance ?significanceLabel
  ?quote
  ?project_phase ?project_phaseLabel
  (CONCAT("#projectphase/", SUBSTR(STR(?project_phase), 38)) AS ?project_phaseUrl) 
  ?project_type ?project_typeLabel
  (CONCAT("#projecttype/", SUBSTR(STR(?project_type), 38)) AS ?project_typeUrl) 
  ?report ?reportLabel
  (CONCAT("#report/", SUBSTR(STR(?report), 38)) AS ?reportUrl) 
  ?link ?linkUrl
WHERE {
  ?pattern dreamst:P2 dreams:Q263 ;
          dreamst:P34 / dreamst:P10* target:
  OPTIONAL { ?pattern dreamst:P33 ?effect . }
  OPTIONAL { ?pattern dreamst:P18 ?quote . }
  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 {
      ?report dreamst:P40 ?miljøportal .
      ?pattern dreamst:P46 ?page .
      BIND(CONCAT(?page, " ↗") AS ?link2)
      BIND(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", ?miljøportal,
                  "#page=", ?page) AS ?link2Url)
    }
    # This doesn't not make sense
    BIND(COALESCE(?link2, ?link1) AS ?link)
    BIND(COALESCE(?link2Url, ?link1Url) AS ?linkUrl)
  }
  OPTIONAL { ?pattern dreamst:P21 ?significance }  # / dreamst:P44 ?symbol . }
  # BIND(IF(BOUND(?symbol), ?symbol, "❓") AS ?significance)
  OPTIONAL { ?pattern dreamst:P19 ?project_phase . }
  OPTIONAL { ?pattern dreamst:P16 ?project_type . }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}
}
}}
}}