Changeset 35097

Timestamp:

2021-04-22T14:58:32+12:00 (3 years ago)

Author:

davidb

Message:

Minor tidy up. Also introduced commented-out block of code for showing from 'first place to last place' as alternative to 'from hero to zero'

File:

• main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/got-nul-point-after-winning.xsl (modified) (2 diffs)

main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/got-nul-point-after-winning.xsl

@@ -21 +21 @@
 PREFIX gsdlextracted: <http://greenstone.org/gsdlextracted#>
 
-SELECT (?country) (COUNT(?country) AS ?freqCount)        
+SELECT (?country AS ?Country) (COUNT(?country) AS ?freqCount)        
 WHERE {
     GRAPH &lt;</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>&gt;  {
-#        ?esc_entrant_uri dc:Relation.isPartOf &lt;</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>&gt;.
-
         ?esc_entrant_uri gsdlextracted:Country ?country.
     ?esc_entrant_uri gsdlextracted:Place ?place.
@@ -35 +33 @@
     BIND(?year_int + 1 AS ?next_year_int).
     BIND(str(?next_year_int) AS ?next_year).
-    
-#        ?esc_entrant_uri gsdlextracted:Final "true".
 
         ?next_esc_entrant_uri gsdlextracted:Country ?country.
     ?next_esc_entrant_uri gsdlextracted:Year ?next_year.
-    
+
+    # The following block tests for 'nul point'
         ?next_esc_entrant_uri gsdlextracted:VoteGrandTotal ?total.
         BIND(xsd:integer(?total) AS ?total_int).
-        FILTER(?total_int = 0).   
+        FILTER(?total_int = 0).
+
+    # If you want to see who went from first to last place
+    # (which could still mean you scored some points) then
+    # comment out the block above, and uncommment the following
+    # one
+
+#        ?next_esc_entrant_uri gsdlextracted:ReverseFinishingPos ?rev_finishing_pos.
+#        BIND(xsd:integer(?rev_finishing_pos) AS ?rev_finishing_pos_int).
+#        FILTER(?rev_finishing_pos_int = 1).
    }
 }