Changeset 35050

Timestamp:

2021-04-11T00:07:25+12:00 (3 years ago)

Author:

davidb

Message:

New example; tweak of list of winners comment

Location:

main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz

Files:

• list-of-losers.xsl (added)
• list-of-winners.xsl (modified) (5 diffs)

main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/list-of-winners.xsl

@@ -11 +11 @@
   <xsl:template name="ssv-list-of-winners">
 
-        
+
+
+    
         <div id="ssv-list-of-winners" style="display: none;">
 
-<!-- Determine if their is any bias in the position in the competition for where you perform in the lineup -->
+<!-- Work out the ESC list of winners from gsdlextracted:Place = 1 filter -->
 <xsl:text>
 PREFIX rdfs: &lt;http://www.w3.org/2000/01/rdf-schema#&gt;
@@ -20 +22 @@
 PREFIX gsdlextracted: &lt;http://greenstone.org/gsdlextracted#&gt;
 
-SELECT (?year AS ?Year) (?country AS ?Country) (?title as ?Title) (?creator as ?Artist)
+SELECT (?year AS ?Year) (?country AS ?Country) (?title as ?Title) (GROUP_CONCAT(?creator; SEPARATOR="; ") AS ?Artist)
 WHERE {
     GRAPH &lt;http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>&gt;  {
@@ -33 +35 @@
    }
 }
-ORDER BY ?year ?country ?title
+GROUP BY ?year ?country ?title   
+ORDER BY ?year ?country
 </xsl:text>
         </div>
@@ -45 +48 @@
 <!-- -->
 <xsl:text>
-title=Eurovison Hall of Fame: Winners Through the Ages|height=800|width=750|fontSize=11
+title=Eurovison Hall of Fame: Winners Through the Ages|height=800|width=700|fontSize=11
 </xsl:text>
         </div>
@@ -52 +55 @@
 <!-- -->
 <xsl:text>
-  width:900px; height:400px; margin-left: auto; margin-right: auto; overflow-y: scroll; overflow-x: hidden;
+  width:710px; height:400px; margin-left: auto; margin-right: auto; overflow-y: scroll; overflow-x: hidden;
   color: black; background-color: white;
 </xsl:text>