Template talk:Wikidata list

From Wikidata
Jump to navigation Jump to search


User:Magnus Manske - can one sort by two things? Comma e.g. sort=P1,P2 seems not to work. 11:59, 25 May 2016 (UTC)

You can sort by multiple columns with "ORDER BY" syntax in SPARQL queries. --Lockal (talk) 21:28, 25 May 2016 (UTC)


Shouldn’t the “WQS” link above the table read “WDQS”? That seems to be the usual acronym as far as I’m aware. --TweetsFactsAndQueries (talk) 19:48, 4 March 2017 (UTC)

✓ Done after no one objected for almost a year :) --TweetsFactsAndQueries (talk) 19:50, 24 February 2018 (UTC)

Support entities other than items[edit]

@Magnus Manske: it would be great if we could also construct lists of other types of entities than just items, e. g. lists of all properties with a certain constraint (example). Currently, only items returned by the query are included in the list, and the properties are discarded. --Lucas Werkmeister (WMDE) (talk) 12:34, 19 May 2017 (UTC)

I ran into this problem and tried to use random items by using RAND() as a workaround, but it is unexpectedly bound only once per query by Blazegraph it seems. Probably more bug than feature. :-/ --Marsupium (talk) 14:32, 15 June 2018 (UTC)
You could use Property:P5176 for workarounds. Personally, I use "subject item", but that isn't necessarily present.
--- Jura 14:50, 15 June 2018 (UTC)

Table width[edit]

Is it possible to use a custom table width in the auto-generated table? --Cavernia (talk) 12:47, 20 May 2017 (UTC)

At Wikidata:WikiProject Lighthouses/numbers, I placed the tables within a table.
--- Jura 14:47, 20 May 2017 (UTC)
Thanks! --Cavernia (talk) 19:38, 20 May 2017 (UTC)

Local date format[edit]

Is it possible to present dates in different formats? --Cavernia (talk) 18:59, 23 May 2017 (UTC)

Same for measurements. And is there any possibility to include unit? --Cavernia (talk) 12:42, 26 May 2017 (UTC)

label don't work?[edit]

User:Magnus Manske Now the resul is like this: <code>[[::d:Q7775214|Категория:Интернет-провайдеры Новосибирска]]</code> double double-point. Can you fix? (example) --ValterVB (talk) 09:19, 19 August 2017 (UTC)

Strange, the problem is only in category items (P31=Q4167836). --ValterVB (talk) 16:14, 19 August 2017 (UTC)
@Magnus Manske: Also Wikidata:Database reports/to delete/empty category items has the same problem. --ValterVB (talk) 16:14, 23 August 2017 (UTC)

Section from a non-direct property[edit]


I try to break this list into sections by a property that is not directly one of the listed items. These are the parameters:

SELECT ?item ?constituency ?party ?localisation
  ?item wdt:P31 wd:Q5 .
  ?item p:P39 ?mandate .
  ?mandate rdf:type wikibase:BestRank ; ps:P39 wd:Q17506823 ; pq:P2937 wd:Q41655079 ; pq:P768 ?constituency .
  OPTIONAL { ?constituency wdt:P131 ?localisation . } .
  OPTIONAL { ?mandate pq:P1268 ?party . } .
|columns=label:Député,?party:Parti politique,?constituency:Circonscription,?localisation:Localisation,P18:Image

I would like to break the list into sections of ?localisation, but it doesn't seem to work. Is is possible? If so, what is the syntax to use?

Envlh (talk) 12:05, 17 November 2017 (UTC)

--- Jura 12:10, 17 November 2017 (UTC)
Template:Wikidata list (Q19860885). I don't know if it work. Can you try with |section=?localisation  – The preceding unsigned comment was added by ValterVB (talk • contribs).
Thanks, it works! — Envlh (talk) 12:45, 17 November 2017 (UTC)
"?" is indeed the answer.
--- Jura 12:32, 17 November 2017 (UTC)
 :) --ValterVB (talk) 10:01, 18 November 2017 (UTC)

User:Robin van der Vliet/Esperanto/Edziĝoj[edit]

When I press the update button, I receive the error status code "no items", while the button "WQS" does work as intended. Why is this and how can I solve this? Robin van der Vliet (talk) (contribs) 22:17, 6 January 2018 (UTC)

The query don't return single row for item, but return more rows for an item (ex. Q12078075) If I remember well, Wikidatalist don't work if exist more of one row for the same item. --ValterVB (talk) 09:33, 7 January 2018 (UTC)

I have the same problem in Types of films, I suppose. How can I make this list working? --Infovarius (talk) 13:50, 13 March 2018 (UTC)

No context[edit]

The documentation for this template fails to describe the context in which one might use it. The primary purpose of Wikidata is to create items, but you can't put this in an item, so what is it for? Jc3s5h (talk) 12:54, 31 May 2018 (UTC)

@Jc3s5h: Here is some context. --Daniel Mietchen (talk) 21:15, 17 August 2018 (UTC)

Results from multiple wikis, possibly in multiple languages?[edit]

Over at Wikidata:WikiProject Humanitarian Wikidata, I was trying to get a Listeria list for items with sitelinks that have been tagged with the local version of Template:Current (Q5638917):

SELECT ?item ?itemLabel ?type ?typeLabel WHERE {
    SELECT ?item WHERE {
      hint:SubQuery hint:optimizer "None".
      BIND(wd:Q5638917 AS ?template)
      ?templateArticle schema:isPartOf ?wikiProjectUrl;
                       schema:about ?template;
                       schema:name ?templateTitleWithNamespace.
      BIND(STRBEFORE(STRAFTER(?wikiProjectUrl, "https://"), "/") AS ?endpoint)
      BIND(STRAFTER(?templateTitleWithNamespace, ":") AS ?templateTitleWithoutNamespace)
      BIND(CONCAT("hastemplate:\"", ?templateTitleWithoutNamespace, "\"") AS ?gsrsearch)
      SERVICE wikibase:mwapi {
        bd:serviceParam wikibase:endpoint ?endpoint;
                        wikibase:api "Generator";
                        mwapi:generator "search";
                        mwapi:gsrsearch ?gsrsearch;
                        mwapi:gsrlimit "max".
        ?item wikibase:apiOutputItem mwapi:item.
    LIMIT 100
  hint:Prior hint:runFirst "true".
  ?item wdt:P31|wdt:P279 ?type .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

Try it!

This does not currently work because the query service expects the endpoint to be a constant rather than a variable (see Phabricator ticket). However, I could imagine Listeria to do the looping over the different endpoints such that the query service would always be called with a constant for each wiki that has a local equivalent of Template:Current (Q5638917). This is not currently the case but if it were, we run into the next problem — how to display results from multiple sites. For instance, the query

SELECT ?item WHERE { ?item schema:about wd:Q5638917 }

Try it!

runs fine on the query service, yet I do not know how to get Listeria to display these results.

Finally, for use in WikiProjects on Wikidata, it would be really useful to have an output mode that makes use of the {{Q}} template to display list content in the interface language set by the user, but I do not see this amongst the existing options. --Daniel Mietchen (talk) 21:32, 17 August 2018 (UTC)