Difference between revisions of "Device"

From DAAP
Jump to navigation Jump to search
Line 1: Line 1:
 
{{#sparql:
 
{{#sparql:
 +
 
prefix daap: <http://daap.eu/wiki/>  
 
prefix daap: <http://daap.eu/wiki/>  
 
prefix daapProp: <http://daap.eu/wiki/Property:>  
 
prefix daapProp: <http://daap.eu/wiki/Property:>  
Line 5: Line 6:
 
prefix vcard: <http://www.w3.org/2006/vcard/ns#>
 
prefix vcard: <http://www.w3.org/2006/vcard/ns#>
  
select distinct ?link (GROUP_CONCAT(?test; separator=", ") as ?Keywords)   
+
select distinct (?device as ?labelLink) ?label ?picture
?picture  (GROUP_CONCAT(?contact; separator="<br/>") as ?contacts)   
+
(GROUP_CONCAT(CONCAT('{{Device/keyword|link=',?item,'|label=',?itemLabel,'}}'); separator=", ") as ?keywords)   
?linkLabel
+
(GROUP_CONCAT(CONCAT('{{Device/contact|contact=',?contact,'|contactLink=',?pilot,'|contactLinkEmail=',?contactLinkEmail,'}}'); separator="<br/>") as ?contacts)   
 
where {
 
where {
?link
+
  ?device
  rdf:type daap:Device ;
+
      rdf:type daap:Device ;
  daapProp:piloteProcess ?pilot ;
+
      daapProp:piloteProcess ?pilot ;
rdfs:label ?linkLabel .
+
      rdfs:label ?label .
 
 
?pilot vcard:email ?contactEmail .
 
?pilot vcard:fn ?contactfn .
 
 
 
  BIND(CONCAT( "[",?contactEmail," ",?contactfn,"]") AS ?contact)
 
 
 
        FILTER langMatches( lang(?linkLabel), "EN" )
 
OPTIONAL{
 
?link  daapProp:picture ?picture .
 
}
 
 
 
OPTIONAL{
 
?link daapProp:item ?item .
 
?item rdfs:label ?itemLabel .
 
  
        FILTER langMatches( lang(?itemLabel), "EN" )
+
  ?pilot vcard:email ?contactLinkEmail .
 +
  ?pilot vcard:fn ?contact .
  
   BIND(CONCAT( "[",?item," ",?itemLabel,"]") AS ?test)
+
   FILTER langMatches( lang(?label), "EN" )
}
+
  OPTIONAL{
      }  
+
          ?device  daapProp:picture ?picture .
 +
  }
 +
  OPTIONAL{
 +
          ?device daapProp:item ?item .
 +
          ?item rdfs:label ?itemLabel .
 +
          FILTER langMatches( lang(?itemLabel), "EN" )  
 +
  }
 +
}  
 +
GROUP BY ?device ?label ?picture
 +
ORDER BY ?label
  
GROUP BY ?link ?linkLabel ?picture
 
ORDER BY ?linkLabel
 
 
|endpoint=http://opendata1.opendata.u-psud.fr/sparql
 
|endpoint=http://opendata1.opendata.u-psud.fr/sparql
| headers = Device , Keywords ,Picture,Contact
+
|headers = Device , Keywords ,Picture,Contact
|templates=link,,,
+
|templates=Device/label,Device/keywords,Device/picture,Device/contacts
 
}}
 
}}

Revision as of 07:50, 30 September 2015

Device Keywords Picture Contact
14:09:45 11/28/2021 -- Refresh -- Duration of query :0.042s