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.
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