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

table Title, URL, File
from "Pocket notes"
WHERE contains(string(URL),"youtube") OR  contains(string(URL),"")

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.

  • WHERE !=
  • WHERE !contains(, "word")
1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.