List all notes that have a tag with a particular string

Things I have tried

Blockquote ```dataview
TABLE WITHOUT ID
(tag + “(” + length(rows.file.link) + “)”) AS Tags,
sort(rows.file.link) AS Files
FROM “”
WHERE econtains(string(tags), “Design/”)
FLATTEN file.etags AS tag
GROUP BY tag
SORT tag asc


I get this: 
![image|690x263](upload://9TfwoaSpgWkdtyuWcQsR40qoIxY.png)


<!-- THIS PART WON'T BE POSTED

We strongly recommend searching in the help docs (F1 in the app or online at https://help.obsidian.md) or this forum (https://forum.obsidian.md/search) before you post. It's always sweet to find answers so you don't have to spend time writing up the post!

If you still can't find it, please write what you have tried below (e.g. "I searched Mermaid in help docs but couldn't find anything") so that we have a better idea how to improve our help docs and this forum.

Please continue below this line: -->



### What I'm trying to do

I am trying to list all the notes that have a tag with a particular string ("Design/")

The issues: 
- When a note have more than one tag, the note is included in the table for each tag - even the tags that to no contain the string ("Design/"). 

Questions: 
1- Any idea how to list the note only for the tag that contains the particular string?


<!-- THIS PART WON'T BE POSTED

Please describe what you're trying to accomplish so the community can better help you. Sometimes the solution you have in mind is not necessarily the best option, in which case knowing some background info can let others come up with creative solutions for your use case.

Please continue below this line. -->

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.