exclude table item where file contains "<% tp.file.cursor(0) %>"

[joshuawagner]

I have the following query that creates a book list.

TABLE WITHOUT ID title as title, author as author, statRead as read, rating AS "Rating", yearRead as "year read"
WHERE contains(itemType, "book")

My problem is that since the query is itemType = "book", my book template is always included as well. I'd like to exclude the template by filtering out any file that contains <% tp.file.cursor(0) %>. 1️⃣ How do I do this?

2️⃣ How do I make the title field a clickable link (like the filename field removed by adding "WITHOUT ID"?

[AB1908]

You can exclude files with where file.name != "template file name" or some other where condition that makes sense.

[joshuawagner]

Alright, that partially answers my Q#1️⃣. Thank you!

Here's what I have now

TABLE WITHOUT ID title as title, author as author, statRead as read, rating AS "Rating", yearRead as "year read"
WHERE contains(itemType, "book") AND file.name != "tem-is-book✅" AND file.name != "typeBook"

Do you know if there's a way to exclude based on text content of a file?

[AB1908]

File content cannot be queried against, you must use file metadata.

[AnnaKornfeldSimpson]

For 1: I filter out my templates by excluding the folder that they are in FROM -"templates"
For 2: file.link gives the link to the file in the same what that file.name gives the name of the file.
If you want to construct your own link with display text, there is a helper function link(path, displayText) that might be useful.

[joshuawagner]

Thank you! Here's what I ended up with.

TABLE WITHOUT ID link(file.name, title), author, year, row["Zotero container"] AS "Zotero Container", uri AS "Zotero"
WHERE contains(objType, "literature") AND !contains(file.folder, "template")