Dreams:effect: Difference between revisions

From DREAMS
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
== Affected ==
== Data ==
{{SPARQL | query=
{{SPARQL | query=
PREFIX target: <https://dreams.wikibase.cloud/entity/Q6>
PREFIX target: <https://dreams.wikibase.cloud/entity/Q12>
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 7: Line 7:
PREFIX dreamspsv: <https://dreams.wikibase.cloud/prop/statement/value/>  
PREFIX dreamspsv: <https://dreams.wikibase.cloud/prop/statement/value/>  


SELECT
SELECT DISTINCT ?description ?value ?valueLabel ?valueUrl
  ?pattern ?patternLabel
  (CONCAT("#pattern/", SUBSTR(STR(?pattern), 38)) AS ?patternUrl) 
 
  ?affected ?affectedLabel
  (CONCAT("#effect/", SUBSTR(STR(?affected), 38)) AS ?affectedUrl) 
 
  ?quote
 
  ?project_phase ?project_phaseLabel
  (CONCAT("#project-phase/", SUBSTR(STR(?project_phase), 38)) AS ?project_phaseUrl) 
 
  ?project_type ?project_typeLabel
  (CONCAT("#project-type/", SUBSTR(STR(?project_type), 38)) AS ?project_typeUrl) 
 
  ?report ?reportLabel
  (CONCAT("#report/", SUBSTR(STR(?report), 38)) AS ?reportUrl) 
 
WHERE {
WHERE {
   ?pattern dreamst:P2 dreams:Q263 ;
   BIND(target: AS ?effect)
          dreamst:P33 target: ;
  {
          dreamst:P34 ?affected ;
    BIND(1 AS ?order)
          dreamst:P18 ?quote ;
    BIND("Effect" AS ?description)
          dreamst:P20 ?report .
    ?effect dreamst:P1 ?value .
   OPTIONAL { ?pattern dreamst:P19 ?project_phase . }
   }
   OPTIONAL { ?pattern dreamst:P16 ?project_type . }
  UNION
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
  {
}
    BIND(5 AS ?order)
    BIND("Superconcept" AS ?description)
    target: dreamst:P10 ?value .
    BIND(SUBSTR(STR(?value), 38) AS ?q)
    BIND(CONCAT("#value/", ?q) AS ?valueUrl)
  }
   UNION
  {
    BIND(6 AS ?order)
    BIND("Subconcepts" AS ?description)
    target: ^dreamst:P10 ?value .
    BIND(SUBSTR(STR(?value), 38) AS ?q)
    BIND(CONCAT("#value/", ?q) AS ?valueUrl)
  }
}}
}}

Revision as of 15:05, 11 August 2022

Data

PREFIX target: <https://dreams.wikibase.cloud/entity/Q12>
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 DISTINCT ?description ?value ?valueLabel ?valueUrl
WHERE {
  BIND(target: AS ?effect)
  {
    BIND(1 AS ?order)
    BIND("Effect" AS ?description)
    ?effect dreamst:P1 ?value .
  }
  UNION
  {
    BIND(5 AS ?order)
    BIND("Superconcept" AS ?description)
    target: dreamst:P10 ?value .
    BIND(SUBSTR(STR(?value), 38) AS ?q) 
    BIND(CONCAT("#value/", ?q) AS ?valueUrl)
  }
  UNION
  {
    BIND(6 AS ?order)
    BIND("Subconcepts" AS ?description)
    target: ^dreamst:P10 ?value .
    BIND(SUBSTR(STR(?value), 38) AS ?q) 
    BIND(CONCAT("#value/", ?q) AS ?valueUrl)
  }