Template:Wikidata list

Documentation icon Template documentation[view · edit · history · purge ]
This manual might be out of date, please check with the master copy!

Usage edit

This template defines a bot-generated list based on Wikidata (original blog post). It must be "closed" with {{Wikidata list end}}; the text between these two templates will be periodically (once every 24h) replaced by the bot-generated list.

The query MUST include the ?item variable - do not rename it.

Example:

{{Wikidata list
|sparql=SELECT ?item WHERE {
   ?item wdt:P31 wd:Q39715 .
   ?item (wdt:P131)* wd:Q55 
  }
|columns=label:Article,description,p131:Place,P580,P582,p625,P18
|section=131
|min_section=3
|sort=label
|links=text
|thumb=128
|autolist=fallback
|summary=itemnumber
|wdedit=yes
}}
... (This will be overwritten by ListeriaBot) ...
{{Wikidata list end}}

Parameters:

sparql
A SPARQL SELECT query. Needs to return ?item as the item number. Mandatory.
See SPARQL query service examples suitable for Listeria
columns
Defines the columns of the list table. Allowed values are :
  • number, a serial row number (per section), increasing from 1, according to the initial sorting
  • label, the wiki-language-based label of the item, linked to the local article (where exists), or the Wikidata item
  • label/xx, the wiki-language-based label of the item, using the given language code (here, "xx"), as plain text
  • alias/xx, the wiki-language-based list of aliases for the item, using the given language code (here, "xx"), as plain text.
  • description, the manual, or auto-generated description
  • item, the Q item number
  • Pxxx a Wikidata property
  • Pxxx/Pzzz, qualifier properties; for Pxxx linking to an item Qyyy and having a Pzzz qualifier, the Qxxx linked label and the value of Pzzz
  • Pxxx/Qyyy/Pzzz, qualifier properties; for Pxxx linking to an item Qyyy and having a Pzzz qualifier, the value of Pzzz. This is a version of the above, specific for a single item; e.g., "p553/q866/p554" to get YouTube account names.
  • ?fieldname, a SPARQL result field name.
Every column can optionally have a :Title suffix, otherwise the Wikidata property (language) name is used. Case sensitive. Since the release of May 2021 single quotes are not supported (causes the query to fail with a "not edited" message).
sort
The initial sort key for the table. Valid values are:
  • label, the label of the item
  • family_name, tries to find, and sort by, the family (last) name from the label, assuming items are people. This is a heuristic and may not work properly in all cases. If possible, try to sort by P734 (family name).
  • Pxxx, a Wikidata property
Optional
section
The list can be sectioned by a Wikidata property. Optional. Can be a property number (possibly prefixed by P), or a ?fieldname (using variables does not work anymore).
min_section
The minimum number of entries to generate a section when used together with section. All other entries will be put under section "misc". Default:2. Optional
autolist
If description is a column but no description exists on Wikidata, "autolist=fallback" uses AutoDesc to generate one. Optional
language
Label/description language, if different from site language. Optional
thumb
The thumbnail width for images (e.g. column P18). Default:128. Optional
links
How to render links not in the local Wikipedia. Valid values are:
  • all to link to Wikidata. Default.
  • local to remove entries for which there exists no local article (the opposite of red_only).
  • red to generate red links based on label and item.
  • red_only to remove entries for which there exists a local article (the opposite of local).
  • text to generate blue links for existing pages, and plain text otherwise.
  • reasonator to generate blue links for existing pages, and links to Reasonator otherwise.
Optional
row_template
Generates a template call rather than a table row; the template must then generate the table row in turn or the table header/footer need to be surpressed using skip_table parameter. Parameters passed to the template are the lower-case keys from the columns parameter, e.g. label or p18. Optional
header_template
Generates a template call rather than a table header; the template must then generate the table header. No parameters are passed to this template. Recommended to be used with row_template. Optional
skip_table
Suppresses the table markup completely when using row_template. Any value will work.
wdedit
Generates information that allows Wikidata editing from Wikipedia using this JavaScript. Value needs to be yes. Does not work when row_template is used. Caution: This will result in larger wikitext than normal, and updates may fail because of that. Optional
references
Add references. Allowed value is all. Requires {{Reflist}} or similar somewhere in the page. Optional
freq
Numerical value X; wait at least X days before an automatic update. Does not affect updates via web interface. Optional
summary
Comma-separated list of keys to add as a summary underneath all other content. Optional
  • itemnumber The total number of items (rows) in this list.
short
Any value ensures that the query is not displayed. Optional
additional
Any value ensures that the "manually update" link is not displayed. Useful for pages with several Listeria lists. Optional

Charts edit

Listeria can be combined with Template:Graph:Chart

Sample from Wikidata:Samples/charts/bar chart:

{{Wikidata list
|sparql=

SELECT
  (wd:Q2481549 as ?item) 
  ("rect" as ?type)
  ("400" as ?width) 
  ("200" as ?height) 
  ("Number of zoos with polar bears" as ?legend) 
  ("country" as ?xAxisTitle) 
  ("zoos" as ?yAxisTitle)
  (GROUP_CONCAT(?country;separator=",") as ?x)
  (GROUP_CONCAT(?count;separator=",") as ?y)
WHERE
{
  { 
    SELECT ?country (COUNT(DISTINCT ?zoo) as ?count)
    {
      ?zoo wdt:P1990 wd:Q33609 . 
      ?zoo wdt:P31 wd:Q43501 .
      ?zoo wdt:P17 / wdt:P901 ?country .
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
    }
    GROUP BY ?country
    ORDER BY ASC(?count) ?country
  }
}

|columns=?type,?width,?height,?legend,?xAxisTitle,?yAxisTitle,?x,?y
|short=true
|chart=true
|skip_table=true
|row_template=Graph:Chart
}}

{{Wikidata list end}}

Important are "row_template", "skip_table" and the columns required by Template:Graph:Chart.

In the sample type is set to "rect". Other charts are possible (line, area, pie).

Listeria generates a single line that looks like:

{{Graph:Chart
| type = rect
| width = 400
| height = 200
| legend = Number of zoos with polar bears
| xaxistitle = country
| yaxistitle = zoos
| x = US,FR,GM,CA,DA,NL,JA,EZ,AS,UK,SN,RS,PL,NZ,FI,EN,AU
| y = 23,5,4,4,3,2,2,2,2,1,1,1,1,1,1,1,1
}}

This (or more recent data) renders as:

End of automatically generated list.

Support edit

To report issues or propose new ideas, click on Support