I’d like to suggest a roon feature. It seems like it should have been discussed, but my admittedly cursory search could not find a similar request. Roon has built a nice database for my music collection, and supports reasonably rich queries against that database that result in a very nice graphical view of my query results: “show me all my albums in the blues and folk categories that I have listened to in the last month”, etc.
It would be extremely useful to be able to create traditional reports that can be exported (likely as text or csv). This would allow users to use the results of queries to reorganize their music, fix errors, etc efficiently, using other programs, command line/scripts, whatever.
As a specific example, I have a friend who is a jazz freak but only does vinyl. If roon generated reports, I could use roon to query “find all my jazz albums I’ve listened to in the last month that are rated 9”, export that as a report, and send it to my jazz-loving vinyl friend for discussion. There are likely many use cases. Proprietary material such as some of the album information from industry databases might need to be filtered out, but otherwise this seems straightforward, and would be highly useful for some of us.
There is the export as CSV/Excel feature but it may not be available for the queries you are thinking of. You can export a particular focus result, for example, but I tried to construct a query including “listened to in the last month” and don’t know how to do that. Am I missing a trick?
does some but maybe you want more (I did want more: to see a column with unavailable from streaming)

Thanks to both of you. @Suedkiez , “listened to in the last month” is one of the standard selections in “focus” on the albums page.
This is a silly admission, but I keep forgetting about the capability to do “select all” on the albums page. I seldom find issue with the fine roon interface, but this is a case where I think it should be more obvious. As @Traian_Boldea says, you can select all for any album search, but its sort of hidden: you have to right click on one album to bring up the menu option “select all”.
Since you can use all the focus and tag searching, then select the resultant albums and use the “select all” option to export, this meets my need. My suggestion is reduced to a simple one to reconsider how a naive user finds the “select all” option… Heres a report listing all the jazz albums I listened to and rated 8 in the last month: genre and “last month” come from the focus entries, while the ratings are a tag I generate for all my music.
Thanks, I missed that
Long left click works as well, which is more consistent with “press and hold” on mobile. But yeah it’s not super obvious and there are quite many posts on the forum where members don’t know how to multiselect. It is mentioned in the help
But it is the same problem like with shortcut modifier keys in all applications. There’s also lots of people who don’t know how to use Ctrl, Shift, and Alt modifiers in Windows and applications on Windows, for instance. It’s not super easy to solve either because the point of modifiers is that you don’t want to clutter the screen, but at the same time they are difficult to discover


