DataView DQL missing *NOT*

Things I have tried

I’ve looked through the help pages and NOT seems unavailable.
In SQL the NOT command is used with WHERE to only include rows where a condition is not true.

What I’m trying to do

I have 2000 notes from the Pocket system as markdown files. Many sourced from YouTube, lots from elsewhere.

I want to have a note listing all the non-YouTube entries.
I’ve created a note that gives all the YouTube notes using

```dataview
table Title, URL, File
from "Pocket notes"
WHERE contains(string(URL),"youtube") OR  contains(string(URL),"youtu.be")

I cannot see how to construct a query returning everything NOT youtube…

It is early days for me with both DataView and Obsidian so all thoughts will be gratefully received

Fair winds
chris :slight_smile:

In DQL you can use in WHERE the ! as negation.
Examples:

  • WHERE file.name != this.file.name
  • WHERE !contains(file.name, "word")
1 Like