SPARQL equivalence for the SQL IN() operator
Asked Answered
L

2

12

Is there a SPARQL equivalence for the SQL IN() operator? I filter my results and now use:

FILTER ( lang(?label) = 'en' )

I want something like:

FILTER ( lang(?label) IN ('en', 'de') )

Is this possible with SPARQL?

Ld answered 27/8, 2011 at 13:32 Comment(0)
H
15

In SPARQL 1.1 yes.

FILTER ( lang(?label) IN ('en', 'de') )

should work.

Pre-1.1 you'll need a big disjunction:

FILTER ( (lang(?label) = 'en') || (lang(?label) = 'de') )
Haller answered 27/8, 2011 at 15:31 Comment(0)
T
3

As per official W3C documentation,

IN

boolean  rdfTerm IN (expression, ...)

The IN operator tests whether the RDF term on the left-hand side is found in the values of list of expressions on the right-hand side. The test is done with "=" operator, which tests for the same value, as determined by the operator mapping.

A list of zero terms on the right-hand side is legal.

Errors in comparisons cause the IN expression to raise an error if the RDF term being tested is not found elsewhere in the list of terms.

The IN operator is equivalent to the SPARQL expression:

(lhs = expression1) || (lhs = expression2) || ...

Examples:

enter image description here

So, IN operator accepts list of vales. Hence below is an example, you can try with SPARQL using FILTER +IN syntax:

SELECT ?s1 
WHERE 
{
      ?s1 rdf:type dbpedia-owl:Scientist.
      FILTER (?s1 IN (<http://example.com/#1>,<http://example.com/#2>, <http://example.com/#3>)) 
 }
Than answered 29/3, 2018 at 4:10 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.