Dreams:report: Difference between revisions

→‎Patterns: Added significance
(Change URL for project type and project phase)
(→‎Patterns: Added significance)
Line 101: Line 101:
   ?object ?objectLabel
   ?object ?objectLabel
   (CONCAT("#effect/", SUBSTR(STR(?object), 38)) AS ?objectUrl)   
   (CONCAT("#effect/", SUBSTR(STR(?object), 38)) AS ?objectUrl)   
  ?significance


   ?quote  
   ?quote  
Line 119: Line 121:
   OPTIONAL { ?pattern dreamst:P19 ?project_phase . }
   OPTIONAL { ?pattern dreamst:P19 ?project_phase . }
   OPTIONAL { ?pattern dreamst:P16 ?project_type . }
   OPTIONAL { ?pattern dreamst:P16 ?project_type . }
  OPTIONAL {
  ?pattern dreamst:P21 ?significance_ .
  BIND(IF(?significance_ = dreams:Q178, "🔴",
        IF(?significance_ = dreams:Q176, "🔴🔴",
        IF(?significance_ = dreams:Q225, "😐",
        IF(?significance_ = dreams:Q231, "😀😀",
        IF(?significance_ = dreams:Q232, "😀",
        "❓"))))) AS ?significance)
  }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}
}