Dataview filter by filename

[RolWg]

I try to filter a dataview table by filename. Some filenames I want to exclude.
I.e. all filenames that begin with the 3 letters “tbs”.
I have the following code, where I want to integrate that filenames beginning with “tbs” are excluded:

TABLE file.name AS "Filename", dateformat(file.mtime, "yyMMdd-HH:mm") AS "LastMod"
FROM ""
WHERE length(file.inlinks) = 0 AND length(file.outlinks) = 0 AND !contains(parent, "") 
WHERE file.name !="dropdown-categories"   AND file.name !="tbs referenz"
SORT file.mtime DESC
LIMIT 50

Here I exclude explizit filenames. But how to exclude the defined group?

[cjt3]

Change

file.name != "tbs referenz"

to

!startswith(file.name, "tbs")

[RolWg]

@cjt3

!startswith(file.name, “tbs”)

Many thanks.
Do you have one more hint for me, where I could have found this on my own?

[holroy]

You could read the documentation at Functions - Dataview