Creating a table from inline metadata

[mjh8431]

I have a a dataview table created from inline metadata statement ScriptureReading::

table ScriptureReading as "Log"
from "Diary/Daily Notes"
where contains(ScriptureReading, "") and file.day >= date(2024-01-01) AND file.day <=date(2024-12-31)
sort file.name desc

Occasionally there are short videos that accompany my daily reading that I would like to include in the table either as a title or as a link. I am thinking of using an inline metadata statement such as VideoComp:: Is it possible to include it in the dataview statement above. I tried adding it to the where statement as an OR contains(VideoComp, "") but that didn't work.

Hopefully someone can help me with this. I really don't want to create a seperate table if I can avoid it.

Thanks

[I-Pch]

Shouldn’t you just add a new field to display on the first line ? 🤔

~~~dataview
table ScriptureReading as "Log", VideoComp as "video"
from "Diary/Daily Notes"
where contains(ScriptureReading, "") and file.day >= date(2024-01-01) AND file.day <=date(2024-12-31)
sort file.name desc
~~~

[rbennett00]

I agree with @I-Pch that just adding a VideoComp field is probably the best way to go and gives you more flexibility. But in case you want to stick with your original approach, this should work (enclose your 'OR' in parentheses)

table ScriptureReading as "Log"
from "Diary/Daily Notes"
where (contains(ScriptureReading,"") OR contains(VideoComp,"")) and file.day >= date(2024-01-01) AND file.day <= date(2024-12-31)
sort file.name desc