LinguaLibre

Difference between revisions of "Records"

(Page créée avec « {{DataViz | query = select ?record ?recordLabel ?locutorLabel ?languageLabel ?languageLevelLabel where { ?record prop:P2 entity:Q2 .... »)
 
m (0x010C moved page DataViz:Records to LinguaLibre:Records: before the deletion of the "DataViz" Namespace)
(13 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
{{DataViz
+
<query _pagination="100" record="Item" audio="Record" recordLabel="Transcription" locutorLabel="Speaker" langLabel="Language" levelLabel="Language level">
−
| query = select ?record ?recordLabel ?locutorLabel ?languageLabel ?languageLevelLabel
+
    select distinct ?record ?audio ?recordLabel ?locutorLabel (if( ?language = entity:Q4, '???', ?languageLabel ) as ?langLabel) (if( ?languageLevel = entity:Q5 || !BOUND(?languageLevel), '???', ?languageLevelLabel ) as ?levelLabel)
−
            where {
+
    where {
−
              ?record prop:P2 entity:Q2 .
+
        ?record prop:P2 entity:Q2 .
−
              ?record prop:P5 ?locutor .
+
        ?record prop:P5 ?locutor .
−
              ?record prop:P4 ?language .
+
        ?record prop:P3 ?audio .
 +
        #extra:{"type": "wikibase-item", "filter":"Q3", "label": "P5", "multiple": true} ?record prop:P5 entity:[EXTRA] .
 +
        ?record prop:P4 ?lang .
 +
        #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] .
 +
        BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
  
−
              ?locutor llp:P4 ?languageStatement .
 
−
              ?languageStatement llv:P4 ?language .
 
−
              ?languageStatement llq:P13 ?languageLevel .
 
  
−
              SERVICE wikibase:label {
+
      OPTIONAL {
−
                bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr,en" .
 
−
              }
 
  
−
             } ORDER BY ?languageLabel ?languageLevelLabel
+
          ?locutor llp:P4 ?languageStatement .
−
}}
+
          ?languageStatement llv:P4 ?language .
 +
          ?languageStatement llq:P16 ?level .
 +
          #extra:{"type": "wikibase-item", "filter":"Q5", "label": "P16", "multiple": true} ?languageStatement llq:P16 entity:[EXTRA] .
 +
          BIND( IF( isBLANK(?level), entity:Q5, ?level ) as ?languageLevel ).
 +
}
 +
         
 +
        ?record prop:P7 ?transcription.
 +
        #extra:{"type": "string", "label": "P7"}  filter contains(lcase(?transcription), lcase('[EXTRA]')).
 +
 
 +
        SERVICE wikibase:label {
 +
            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 +
             ?languageLevel rdfs:label ?languageLevelLabel.
 +
            ?record rdfs:label ?recordLabel.
 +
            ?locutor rdfs:label ?locutorLabel.
 +
            ?language rdfs:label ?languageLabel.
 +
        }
 +
    } ORDER BY ?recordLabel
 +
</query>

Revision as of 09:23, 25 December 2018

... Loading ...
Retrieved from "https://lingualibre.org/index.php?title=LinguaLibre:Records&oldid=64968"