ਫਰਮਾ:Wikidata list
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: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 sortinglabel
, the wiki-language-based label of the item, linked to the local article (where exists), or the Wikidata itemlabel/xx
, the wiki-language-based label of the item, using the given language code (here, "xx"), as plain textalias/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 descriptionitem
, the Q item numberPxxx
a Wikidata propertyPxxx/Pzzz
, qualifier properties; for Pxxx linking to an item Qyyy and having a Pzzz qualifier, the Qxxx linked label and the value of PzzzPxxx/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 itemfamily_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
. - 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 ofred_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 oflocal
).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 thecolumns
parameter, e.g.label
orp18
. 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 whenrow_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
ਸੋਧੋ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:
{{Wikidata:Samples/charts/bar chart}}