Michael added subscribers: Manuel, Michael. Michael added a comment.
I spent a little bit of time and looked into this again. I made a proof concept that you can see at https://63b46c4dda28e91d2de76ebe--clicky-sparqly.netlify.app/. Also, I prepared a nice example query <https://63b46c4dda28e91d2de76ebe--clicky-sparqly.netlify.app/?query=%7B%22conditions%22%3A%5B%7B%22propertyId%22%3A%22P31%22%2C%22propertyDataType%22%3A%22wikibase-item%22%2C%22propertyValueRelation%22%3A%22matching%22%2C%22referenceRelation%22%3A%22regardless%22%2C%22value%22%3A%22Q5%22%2C%22subclasses%22%3Atrue%2C%22conditionRelation%22%3Anull%2C%22negate%22%3Afalse%7D%2C%7B%22propertyId%22%3A%22P569%22%2C%22propertyDataType%22%3A%22time%22%2C%22propertyValueRelation%22%3A%22regardless-of-value%22%2C%22referenceRelation%22%3A%22regardless%22%2C%22value%22%3A%22%22%2C%22subclasses%22%3Afalse%2C%22conditionRelation%22%3A%22and%22%2C%22negate%22%3Afalse%7D%2C%7B%22propertyId%22%3A%22P21%22%2C%22propertyDataType%22%3A%22wikibase-item%22%2C%22propertyValueRelation%22%3A%22regardless-of-value%22%2C%22referenceRelation%22%3A%22regardless%22%2C%22value%22%3A%22%22%2C%22subclasses%22%3Atrue%2C%22conditionRelation%22%3A%22and%22%2C%22negate%22%3Afalse%7D%5D%2C%22limit%22%3A3%2C%22useLimit%22%3Atrue%2C%22omitLabels%22%3Atrue%7D>. It shows one column for every unique property used in a condition, regardless of what kind of condition it is. Also, it does not yet show labels for `wikibase-item` columns. However, this does not work great with cases where there is more than one value per property, see for example: Items with the postal code 10777 or 10317 <https://63b46c4dda28e91d2de76ebe--clicky-sparqly.netlify.app/?query=%7B%22conditions%22%3A%5B%7B%22propertyId%22%3A%22P281%22%2C%22propertyDataType%22%3A%22string%22%2C%22propertyValueRelation%22%3A%22matching%22%2C%22referenceRelation%22%3A%22regardless%22%2C%22value%22%3A%2210777%22%2C%22subclasses%22%3Afalse%2C%22conditionRelation%22%3Anull%2C%22negate%22%3Afalse%7D%2C%7B%22propertyId%22%3A%22P281%22%2C%22propertyDataType%22%3A%22string%22%2C%22propertyValueRelation%22%3A%22matching%22%2C%22referenceRelation%22%3A%22regardless%22%2C%22value%22%3A%2210317%22%2C%22subclasses%22%3Afalse%2C%22conditionRelation%22%3A%22or%22%2C%22negate%22%3Afalse%7D%5D%2C%22limit%22%3A5%2C%22useLimit%22%3Atrue%2C%22omitLabels%22%3Atrue%7D> @Lydia_Pintscher or @Manuel: Let me know if we should spent a bit more time on this and what aspects would be important to you. TASK DETAIL https://phabricator.wikimedia.org/T277646 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: guergana.tzatchkova, Michael Cc: Michael, Manuel, amy_rc, Tonina_Zhelyazkova_WMDE, Addshore, Lucas_Werkmeister_WMDE, Aklapper, Lydia_Pintscher, Adamm71, Jersione, Hellket777, LisafBia6531, Astuthiodit_1, 786, Biggs657, karapayneWMDE, Invadibot, maantietaja, Juan90264, Alter-paule, Beast1978, ItamarWMDE, Un1tY, Akuckartz, Hook696, Kent7301, joker88john, CucyNoiD, Nandana, Gaboe420, Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, Bsandipan, GoranSMilovanovic, QZanden, LawExplorer, Lewizho99, Maathavan, _jensen, rosalieper, Neuronton, Scott_WUaS, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list -- [email protected] To unsubscribe send an email to [email protected]
