List files in vault above 1kb

[mlte]

What I’m trying to do

I want to make a list in dataview of all my notes that exceed 1kb in file size. I know I can sort by using file.size. I need to narrow the list to only give me the largest files in my vault.

My way of note-taking builds on a premise that I only take very short and sweet notes. This list could help me do some house cleaning and catch notes that should be broken up into smaller fragments.

Things I have tried

I’m thinking something like

TABLE file.size
WHERE file.size > 1kb
LIMIT 50
SORT file.size desc

(which doesn’t work obviously). What’s the right command?

[holroy]

I reckon it should suffice to write out the size, so try WHERE file.size > 1024 or whatever number of bytes you want.

I would also place the limit after the sorting, to get the correct behaviour.