How do I exclude files with links to specific folders?

Help
1

I’m trying to recover the exported whiteboard structure in Heptabase with Dataview and have run into a problem. There are now two folders:

1 Heptabase/Card Library
2 Heptabase/Whiteboards

In the Card Library in Heptabase, it is possible to filter out orphan cards that are not in any whiteboard. Try replicating this in Obsidian so that you no longer have to manage the cumbersome folder structure and can continue to use the Heptabase whiteboard structure. What I need to filter for are files that are in folder 1 and don’t have any links to folder 2.

I’ve been trying this for a while now and neither method does anything:

``dataview
TABLE
FROM “Heptabase/Card Library”
WHERE
!contains(file.outlinks.file.folder, “Heptabase/Whiteboards”)
OR
!contains(file.outlinks.file.folder, “Heptabase/Whiteboards”)



```dataview
TABLE filter(file.outlinks.file.folder, (l) => l ! = file.outlinks.file.folder, "Heptabase/Whiteboards")
FROM "Heptabase/Card Library"

I did read the Dataview guide and other answers. I don’t understand why “!contains” doesn’t work, when it does in some examples.

2

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