Lucas_Werkmeister_WMDE created this task. Lucas_Werkmeister_WMDE added projects: Wikidata, Wikidata-Query-Service. Restricted Application added a subscriber: Aklapper.
TASK DESCRIPTION As a Wikidata editor, I want the query service to reflect the current data in Wikidata. When a formatter URI for RDF resource <https://www.wikidata.org/wiki/Property:P1921> has been defined, I want it to be consistently applied in the query service, to make it easy to query linked data. **Problem:** When a formatter URI for RDF resource <https://www.wikidata.org/wiki/Property:P1921> statement is added or edited on an external ID property, the RDF output of all items using that property changes (see Normalized External ID <https://www.mediawiki.org/wiki/Wikibase/Indexing/RDF_Dump_Format#Normalized_External_ID>), but the change is not visible in the query service until each affected item is edited, because only then will the query service updater process those items and see the changed value. **Example:** A formatter URI was recently added to TAXREF ID (P3186) <https://www.wikidata.org/wiki/Property:P3186>, but the number of `wdtn:P3186` triples is significantly lower than the number of `wdt:P3186` triples (user report <https://www.wikidata.org/wiki/Special:PermanentLink/1236870834#wdtn:P3186_(TAXREF_ID)_links_missing.>): SELECT ?wdtn ?wdt (CONCAT(SUBSTR(STR(100*?wdtn/?wdt), 1, 5), "%") AS ?percent) WITH { SELECT (COUNT(*) AS ?wdtn) WHERE { [] wdtn:P3186 []. } } AS %wdtn WITH { SELECT (COUNT(*) AS ?wdt) WHERE { [] wdt:P3186 []. } } AS %wdt WHERE { INCLUDE %wdtn. INCLUDE %wdt. } Try it! <https://query.wikidata.org/#SELECT%20%3Fwdtn%20%3Fwdt%20%28CONCAT%28SUBSTR%28STR%28100%2a%3Fwdtn%2F%3Fwdt%29%2C%201%2C%205%29%2C%20%22%25%22%29%20AS%20%3Fpercent%29%0AWITH%20%7B%0A%20%20SELECT%20%28COUNT%28%2a%29%20AS%20%3Fwdtn%29%20WHERE%20%7B%0A%20%20%20%20%5B%5D%20wdtn%3AP3186%20%5B%5D.%0A%20%20%7D%0A%7D%20AS%20%25wdtn%0AWITH%20%7B%0A%20%20SELECT%20%28COUNT%28%2a%29%20AS%20%3Fwdt%29%20WHERE%20%7B%0A%20%20%20%20%5B%5D%20wdt%3AP3186%20%5B%5D.%0A%20%20%7D%0A%7D%20AS%20%25wdt%0AWHERE%20%7B%0A%20%20INCLUDE%20%25wdtn.%0A%20%20INCLUDE%20%25wdt.%0A%7D> | wdtn | wdt | percent | | ----- | ------ | ------- | | 45744 | 179235 | 25.52% | | **Screenshots/mockups:** **BDD** GIVEN AND WHEN AND THEN AND **Acceptance criteria:** - **Open questions:** TASK DETAIL https://phabricator.wikimedia.org/T258685 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Lucas_Werkmeister_WMDE Cc: Aklapper, Lucas_Werkmeister_WMDE, CBogen, Akuckartz, darthmon_wmde, Nandana, Namenlos314, Lahi, Gq86, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
