VladimirAlexiev created this task. VladimirAlexiev added a project: Wikidata. Restricted Application added a subscriber: Aklapper.
TASK DESCRIPTION The SPARQL queries that expose constraint violations return the offending **statement**. But the statement URL is opaque: it's more useful to return the offending **value** (eg one can use it to generate a QS script to remove offending values). Eg for P2088 <https://www.wikidata.org/wiki/Property_talk:P2088> Distinct Values, change SPARQL (new) <https://query.wikidata.org/#%23%20Note%3A%20before%20https%3A%2F%2Fphabricator.wikimedia.org%2FT201150%20is%20fixed%2C%20the%20result%20will%20only%20be%20partial%0ASELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fstatement%20WHERE%20%7B%0A%09%3Fstatement%20wikibase%3AhasViolationForConstraint%20wds%3AP2088-DD4CDCEA-B3F6-4F02-9CFB-4A9E312B73A8%20.%0A%09%3Fitem%20%3Fp%20%3Fstatement%20.%0A%09FILTER%28%20%3Fitem%20NOT%20IN%20%28%20wd%3AQ4115189%2C%20wd%3AQ13406268%2C%20wd%3AQ15397819%20%29%20%29%20.%0A%09SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%20.%0A%7D%0A> to this: SELECT DISTINCT ?item ?itemLabel ?value WHERE { ?statement wikibase:hasViolationForConstraint wds:P2088-DD4CDCEA-B3F6-4F02-9CFB-4A9E312B73A8 . ?item p:P2088 ?statement . ?statement ps:P2088 ?value. SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } . } TASK DETAIL https://phabricator.wikimedia.org/T290641 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: VladimirAlexiev Cc: Aklapper, VladimirAlexiev, Invadibot, maantietaja, Akuckartz, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list -- [email protected] To unsubscribe send an email to [email protected]
