qlever icon indicating copy to clipboard operation
qlever copied to clipboard

missing isBlank and other is... functions

Open pfps opened this issue 1 year ago • 1 comments

I just ran across this. I was trying to remove blank results from a Wikidata query. Please add them, as they should be easy to add.

pfps avatar Dec 09 '23 17:12 pfps

It's on our list. To do it efficiently, we depend on a few other PRs currently in the pipeline. Once they are done, it will indeed be relatively straightforward.

In the meantime, you can use STRSTARTS as a workaround. This is relatively slow (for QLever's standards), so best to put the part of the query you want to filter into { ... }:

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
SELECT ?class WHERE {
  { { ?item wdt:P31 ?class . }
  MINUS { ?class wdt:P279 ?super } }
  FILTER (! STRSTARTS(STR(?class), "_:u_"))
} 

https://qlever.cs.uni-freiburg.de/wikidata/xTLBHK

hannahbast avatar Dec 09 '23 19:12 hannahbast

This was already fixed by #1184, (see above), however the closing did not work as expected.

joka921 avatar May 03 '24 12:05 joka921

Thanks.

pfps avatar May 03 '24 12:05 pfps