Page MenuHomePhabricator
Create Task
Maniphest T277646

Show all columns in the result
Open, MediumPublic5 Estimated Story Points
Actions

Description

As an editor I want to see all values that influence my query result in order to understand what ends up in my query result.

Problem:
We currently only show the Item ID and Label for the resulting Item in the query results view, no additional information. We should show all Property values that are a part of the query.

Example:

  • When you query for instance of human and occupation poet and has any birthdate -> show columns for Item ID, Label, occupation and birthdate

BDD
GIVEN
AND
WHEN
AND
THEN
AND

Acceptance criteria:

  • A column is added to the query result for each Property that is part of the query

Notes:

  • We are not grouping Items that are matching for multiple OR conditions for now.
  • Removal of columns that have the same value for all results will happen in T271296.

Details

ProjectBranchLines +/-Subject
wikidata/query-buildermaster+885 -492Show all columns in the result
Customize query in gerrit

Related Objects

Event Timeline

Lydia_Pintscher created this task.Wed, Mar 17, 10:39 AM
Restricted Application added a project: Wikidata. · View Herald TranscriptWed, Mar 17, 10:39 AM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
Lydia_Pintscher triaged this task as Medium priority.Wed, Mar 17, 10:39 AM
Lydia_Pintscher set the point value for this task to 5.
Lydia_Pintscher moved this task from Incoming to Ready to pick up on the Wikidata Query Builder board.
guergana.tzatchkova claimed this task.Wed, Mar 31, 9:58 AM
guergana.tzatchkova moved this task from Ready to pick up to Doing on the Wikidata Query Builder board.
guergana.tzatchkova added a comment.EditedWed, Mar 31, 11:02 AM

Example query for literal value. Searches for postal code === 6200:

SELECT DISTINCT ?item ?itemLabel ?value0 WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
  {
    SELECT DISTINCT ?item ?value0 WHERE {
      VALUES ?value0 {
        "6200"
      }
      ?item p:P281 ?statement0.
      ?statement0 (ps:P281) ?value0.  
    }
    LIMIT 100
  }
}

Example Query for any value:

SELECT DISTINCT ?item ?itemLabel ?value0 WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
  {
    SELECT DISTINCT ?item ?value0 WHERE {
      ?item p:P281 ?statement0.
      ?statement0 (ps:P281) ?value0.  
    }
    LIMIT 100
  }
}

The VALUES solution is not very easily adaptable to multiple queries and the team has decided to use BIND instead:

Example searching items with property postal code === 6200 and country === Belgium (Q31)

SELECT DISTINCT ?item ?P281_0 ?P17_1 WHERE {
      BIND("6200" AS ?P281_0)
      ?item p:P281 ?statement0.
      ?statement0 (ps:P281) ?P281_0.
      BIND(wd:Q142 AS ?P17_1)
      ?item p:P17 ?statement1.
      ?statement1 (ps:P17/(wdt:P279*)) ?P17_1.
}
LIMIT 3
guergana.tzatchkova added a comment.EditedWed, Mar 31, 12:36 PM

Subqueries could be used to search for items 'not matching'

We still need to find out if subqueries are supported by sparqljs

SELECT ?item ?itemLabel ?instance WITH {
  SELECT DISTINCT ?item ?instance WHERE {
    ?item p:P281 ?statement0.
    ?statement0 (ps:P281) ?instance.
    MINUS { ?item (p:P281/ps:P281) "1350". }
  }
  LIMIT 100
}
AS %results WHERE {
  INCLUDE %results.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
LIMIT 100

The current solution for 'not matching' queries is causing timeouts. See bug report

gerritbot added a comment.Wed, Apr 7, 4:04 PM

Change 677597 had a related patch set uploaded (by Guergana Tzatchkova; author: Guergana Tzatchkova):

[wikidata/query-builder@master] Show all columns in the result

https://gerrit.wikimedia.org/r/677597

gerritbot added a project: Patch-For-Review.Wed, Apr 7, 4:04 PM
guergana.tzatchkova moved this task from Doing to Peer Review on the Wikidata Query Builder board.Wed, Apr 7, 4:04 PM
guergana.tzatchkova moved this task from Peer Review to Doing on the Wikidata Query Builder board.Thu, Apr 8, 1:58 PM
Lucas_Werkmeister_WMDE added a subscriber: Lucas_Werkmeister_WMDE.Thu, Apr 8, 2:33 PM
In T277646#6960332, @guergana.tzatchkova wrote:

We still need to find out if subqueries are supported by sparqljs

Regular subqueries (standard SPARQL) are, named subqueries (Blazegraph extension) aren’t. SPARQL.js#43

guergana.tzatchkova moved this task from Doing to Peer Review on the Wikidata Query Builder board.Fri, Apr 9, 11:27 AM
guergana.tzatchkova moved this task from Peer Review to Doing on the Wikidata Query Builder board.Fri, Apr 9, 1:15 PM
guergana.tzatchkova added a comment.EditedFri, Apr 9, 1:42 PM

Example query for union (OR) of two conditions with different properties: Link to query service

  SELECT DISTINCT ?item ?P281 ?P17 WHERE {
  {
    BIND("10777" AS ?P281)
    ?item p:P281 ?statement0.
    ?statement0 (ps:P281) "10777".
  }
  UNION
  {
    BIND(wd:Q147 AS ?P17)
    ?item p:P17 ?statement1.
    ?statement1 (ps:P17) ?P17.
  }
  OPTIONAL { ?item (p:P281/ps:P281) ?P281 . }
  OPTIONAL { ?item (p:P17/ps:P17) ?P17 . }
}
LIMIT 4

Example query for union (OR) of two conditions with the same property;

SELECT DISTINCT ?item ?P281 WHERE {
  {
    BIND("10777" AS ?P281)
    ?item p:P281 ?statement0.
    ?statement0 (ps:P281) ?P281.
  }
  UNION
  {
    BIND("10317" AS ?P281)
    ?item p:P281 ?statement0.
    ?statement0 (ps:P281) ?P281.
  }
  OPTIONAL { ?item (p:P281/ps:P281) ?P281 . }
}
LIMIT 50
Content licensed under Creative Commons Attribution-ShareAlike 3.0 (CC-BY-SA) unless otherwise noted; code licensed under GNU General Public License (GPL) or other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL