Template:Wikidata list

Template documentation

This manual might be out of date, please check with the master copy!

Usage

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:Item,description,p131:Place,P580,P582,p625,P18
|section=131
|min_section=3
|sort=label
|links=text
|thumb=128
|autolist=fallback
|summary=itemnumber
}}
... (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

To sort by field, use "SORT BY ?fieldname" in SPARQL instead. (see https://github.com/magnusmanske/listeria_rs/issues/142 .)

Optional

sort_order

DESC will reverse the sort order, any other value leaves it ascending.

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

Examples

• See Category:Wikidata lists for examples.

Charts

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:

Manually update chart

WDQS | PetScan | TABernacle | Find images | Recent changes

End of automatically generated list.

Support

To report issues or propose new ideas, click on Support