How can I see all the values for a specific property?

What I’m trying to do

I have a collection of quotes. One of the properties of the notes in my quotes collection is “topics”. I can see by looking at the status of all my properties that there are 548 different topics used. I can easily do a search for notes with the “topics” property and I can do searched for notes that contain a specific topic, but I cannot figure out if there is a way to get a list of all the 548 different topics. I suspect this is going to take some kind of DataviewJS wizard but maybe I’m overlooking something.

I want a list of all the values I have assigned to a certain property. Sort of like you can see all the different tags you use, I just want values from another property called “topics”.

Things I have tried

Various searches and dataview queries.

You mean like in:

LIST length(rows)
WHERE topics
FLATTEN topics as topic
GROUP BY topic
SORT key asc

Untested, but I think it should work. I’ve also thrown in how many times a given topic has been used for good measures. :slight_smile:

You might need to limit that to your quotes collection, as this scans the entire vault…


Damn! You are smarter than Google Gemini (paid version) which has had me trying a million python scripts all afternoon. Many, many thanks!!!

1 Like

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