Hi,
I've generated a livetable.
See code below:
It works good!
It will generated a livetable and extend the table with collumns to the right based on a
query.
Now the header of the column will be _gben, _eses,  _nlnl (etcetera for all
country/language combinations in our wiki)
In the translation table (it is a multilanguage wiki) it will be translated to gben, eses,
nlnl etcetera...
My question is how I can replace these headers with images of countryflags (if at all?)
Could I put a url in the translations file that will render intime?
What piece of code in the default lifetable will take care of the header
Gerritjan
{{include document="CdLSATEPublic.TranslationMatrixHeader"/}}
{{include document="CdLSCountries.Macros"/}}
{{velocity}}
#set($columns =[])
#set($discard = $columns.add("AlphabetSort"))
#set($discard = $columns.add("subject"))
#set($discard = $columns.add("topics"))
#set($discard = $columns.add("SACApproved"))
#set($discard = $columns.add("CountryCode"))
#set($columnsProperties = {
      "AlphabetSort" : { "type" : "text", "link" :
"view", "size" : 1, "filterable" : true,
"sortable": true },
      "subject" : { "type" : "text", "link" :
"view", "size" : 10, "filterable" : true,
"sortable": true },
      "topics" : { "type" : "text", "link" :
"view", "size" : 10, "filterable" : true,
"sortable": true },
      "question" : { "type" : "text", "link" :
"view", "size" : 10, "filterable" : true,
"sortable": true },
      "language" : { "type" : "hidden", "link" :
"none", "size" : 1, "filterable" : false,
"sortable": false },
      "CountryCode" : { "type" : "hidden", "link"
: "view", "size" : 2, "filterable" : false,
"sortable": false },
      "answer" : { "type" : "text", "link" :
"view", "size" : 10, "filterable" : true,
"sortable": true },
      "SACApproved" : { "type" : "text", "link" :
"view", "size" : 4, "filterable" : true,
"sortable": true },
      "_avatar" : { "type" : "none", "link" :
"none", "html" : "true", "sortable":false },
      "_images" : { "type" : "none", "link" :
"none", "html" : "true", "sortable":false },
      "_attachments" : { "type" : "none", "link" :
"none", "html" : "true", "sortable":false },
      "_actions" : { "type" : "none", "link" :
"none", "html" : "true", "sortable":false },
      "doc.name" : { "type" : "text", "link" :
"view", "size" : "10", "filterable" : true,
"sortable": true },
      "doc.space" : { "type" : "text", "link" :
"view", "size" : "10", "filterable" : true,
"sortable": true },
      "doc.fullName" : { "type" : "text", "link" :
"view", "size" : "10", "filterable" : true,
"sortable": true },
      "doc.author" : { "type" : "text", "link" :
"view", "size" : "10", "filterable" : true,
"sortable": true },
      "doc.date" : { "type" : "text", "link" :
"view", "size" : "10", "filterable" : true,
"sortable": true },
      "doc.creator" : { "type" : "text", "link" :
"view", "size" : "10", "filterable" : true,
"sortable": true },
      "doc.creationDate" : { "type" : "text",
"link" : "view", "size" : "10",
"filterable" : true, "sortable": true },
      "doc.title" : { "type" : "text", "link" :
"view", "size" : "20", "filterable" : true,
"sortable": true }
})
#set($options = {
"className":"CdlsatdCode.CdLSATEPublicQAClass",
"translationPrefix" : "cdlsatepublicqa.livetable.",
"topFilters": '<input type="hidden"
size="${columnsProperties.size}"
name="language"value="en"/>',
"topFilters": '<input type="hidden"
size="${columnsProperties.size}"
name="CountryCode"value="us"/>',
"tagCloud" : false,
"rowCount": 15,
"maxPages" : 50,
"selectedColumn" : "AlphabetSort",
"defaultOrder" : "asc"
})
##
## Find the associations
##
#set ($associationQuery = ",
                BaseObject as associations
        where associations.name=doc.fullName
        and associations.className='CdLSAssociations.CdLSAssociationsClass'
        and associations.name<>'CdLSAssociations.CdLSAssociationsTemplate'
        ")
#set($associationList = $xwiki.searchDocuments($associationQuery))
#foreach ($association in $associationList)
   #set ($associationDoc = $xwiki.getDocument($association))
   #set($discard = $associationDoc.use('CdLSAssociations.CdLSAssociationsClass'))
   #set($countriesSupported = $associationDoc.getValue('CountriesServed'))
   #set($languagesSupported = $associationDoc.getValue('languagesSupported'))
   #foreach ($country in $countriesSupported)
      #foreach($language in $languagesSupported)
         #set($CollumnCode = $country + $language)
         #if($CollumnCode != "usen")
           #set($extraCollumn = "_" + ${CollumnCode})
           #set($discard = $columns.add(${extraCollumn}))
           #set($discard = $columnsProperties.put(${extraCollumn} , { "type" :
"text", "link" : "view", "size" : "5",
"filterable" : false, "sortable": false }))
         #end
      #end
   #end
#end
#livetable("cdlsatepublicqa" $columns $columnsProperties $options)
{{/velocity}}