Hide empty dataview queries

Help
2

With a DQL no. But you can use a tricky way in dataviewjs: using your DQL inside DVJS.

Try this way:

// place your query here
const query = `TABLE WITHOUT ID C.text as "Parents"
From "Test_Plugins/Daylie notes/2022/09_Sep"
FLATTEN file.lists as L
WHERE join(L.tags, "") = "#Gratitude-Parents"
FLATTEN L.children as C`

// executing the dataview query and return results
let DQL = await dv.tryQuery(query);

// render the table only if any value
if (DQL.values.length > 0){
	dv.table(DQL.headers, DQL.values)
}

question: what’s the reason to join(L.tags, "") = "#Gratitude-Parents" and not only contains(L.tags, "#Gratitude-Parents")?