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