Where statement is missing files when searching for properties

[KleiDav]

What happened?

In my vault, this DQL below shows only 27 records when I have 45 files with the property "type_note" equals to "knowledge_base"
Tried with other properties, it always misses files.

So what I did is add the tag #kbase to those 45 files, and by changing the DQL to "from #kbase" instead of "where type_note="knowledge_base"" I can now see my 45 files listed.

So to me, doing a request on a property is not showing the real informations.

DQL

table 
where type_note="knowledge_base"
sort file.name desc

JS

No response

Dataview Version

0.5.67

Obsidian Version

1.7.7

OS

Windows