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

[holroy]

What do you get if you do the following query:

```dataview
TABLE
WHERE contains(flat(list(type_note)), "knowledge_base")
SORT file.name desc
```

If this query produces all your files, then it's not a bug but a feature that some of your type_note properties are lists, instead of a single value. The syntax is above is useful to force both single values and lists into a coherent list structure. I found it when needing to query old metadata from before the property update in Obsidian where it was common to intermix properties/fields with either a list or a single value.

[KleiDav]

In fact, my ‘note_type’ is a list and by using this syntax I can see all my notes!
Thanks a lot!

[holroy]

If they're always a list, and never a single value, that is something: singleValue, you could use contains(yourListProperty, "value") to check whether the list has that value.

[KleiDav]

Thanks, I prefer the second syntax, easier to understand :-)
By the way, do you know if possible to force no more than a single value on the property?

[holroy]

If the property is not declared as a list, it's by default just a single value. So in that case, it'll remain a single value and can be used as such until you change your usage of that property.