Dreams:report-index: Difference between revisions

From DREAMS
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
[https://dreams.wikibase.cloud/query/#PREFIX%20dreams%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20dreamst%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%0A%20%20%3Fpublication_datetime%20%0A%20%20%3Freport%0A%20%20%3Ftitle%0AWHERE%20%7B%0A%20%20%3Freport%20dreamst%3AP2%20%2F%20dreamst%3AP10%2a%20dreams%3AQ8%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Freport%20dreamst%3AP1%20%3Ftitle%20.%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Freport%20dreamst%3AP6%20%3Fpublication_datetime%20.%20%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3Fpublication_datetime%20]
{{SPARQL | query=  
{{SPARQL | query=  
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>

Revision as of 12:09, 11 August 2022

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT 
  ?publication_datetime 
  ?report
  ?title
  ?id
  ?url
WHERE {
  ?report dreamst:P2 / dreamst:P10* dreams:Q8 .
  OPTIONAL {
    ?report dreamst:P1 ?title .
  }
  OPTIONAL {
    ?report dreamst:P6 ?publication_datetime . 
  }
  OPTIONAL {
    ?report dreamst:P40 ?id .
    BIND(IRI(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", STR(?id))) AS ?url)
  }
}
ORDER BY DESC(?publication_datetime)
Retrieved from "https://dreams.wikibase.cloud/w/index.php?title=Dreams:report-index&oldid=1736"