Database view improvements

Request a new feature to add to Muso, or vote +1/-1 for anyone else's suggestion. Even just a few votes will get it looked into (just one possibly not).

Database view improvements

Postby Morbeas » Wed May 02, 2018 12:13 am

I recently started using the database view and I'm enjoying the granular editing it allows for. The one feature I would like is to be able to jump to/from album view. I'm looking for a way to click on a track and be able to go that album's page. Same goes for simplifying the way we add tracks from the database view. I think it's redundant to have to select a track and then have to travel down to select the little plus sign (Queue button) to add it to the queue. I was thinking maybe you can implement a right-click menu that one can invoke from any track. This way you can add additional functionality like lyrics lookup and the subsequent tag export, for example. ;)

Also, I would like to see each column contain at the top a drop-down box to select from. For example the "Genre" column would have a drop-down box at the top that I can click on to filter the list by selecting which genres I want included/excluded. This would introduce additional functionality for sorting through our music.

Finally, I would like to see a way to add TrackStat functionality built into the database view. I would love to be able to apply various TrackStat filters to select music and create playlists (least played songs not recently added or not completely rated albums not recently added etc). The way it is right now I have to leave muso and go to the LMS web interface to accomplish this.

As you can see, I'm trying to bring over some of the functionality from the web interface to the database view as I feel this to be a great fit for the use and purpose of the database view while bringing additional functionality and ease-of-use improvements.

Anyway, thanks as always for making an awesome product. :)
Morbeas
 
Posts: 245
Joined: Fri Feb 01, 2013 3:07 pm

Re: Database view improvements

Postby musoware » Wed May 02, 2018 7:42 am

So I'll add these to the TODO list to be prioritised based on anyone else's support for these features:
(1) Way to navigate from track in DB view to Album or Track page - via a context menu - BACK should return to DB View where you came from
(2) Way to filter by specific column values (those with a discrete list could offer that list, others could offer freeform text filter, dates could offer ranges - today, yesterday, this week, etc, or custom date range)
(3) Track-stat like filters (I'll have to get a list of these)

If no-one else votes for these I may end up doing them anyway, since I think they make sense, but more votes will raise the priority and make it happen sooner.
musoware
Site Admin
 
Posts: 1666
Joined: Fri Sep 14, 2012 6:50 am

Re: Database view improvements

Postby DuLac » Thu May 03, 2018 3:06 pm

I vote for #1 and #2. I do not care about track stats but I can see #3 this being useful for other people.
DuLac
 
Posts: 188
Joined: Sun Feb 10, 2013 9:53 am

Re: Database view improvements

Postby Morbeas » Thu May 03, 2018 3:21 pm

Here are the TrackStat stats/filters:

Albums played long ago
Albums rated 1
Albums rated 10
Albums rated 2
Albums rated 3
Albums rated 4
Albums rated 5
Albums rated 6
Albums rated 7
Albums rated 8
Albums rated 9
All albums
All artists
All genres
All playlists
All songs
All years
Artists played long ago
Artists rated 1
Artists rated 10
Artists rated 2
Artists rated 3
Artists rated 4
Artists rated 5
Artists rated 6
Artists rated 7
Artists rated 8
Artists rated 9
Last added albums
Last added artists
Last added songs
Last played albums
Last played artists
Last played songs
Least played albums
Least played albums not recently added
Least played albums recently added
Least played artists
Least played artists not recently added
Least played artists recently added
Least played songs
Least played songs not recently added
Least played songs recently added

Most played albums
Most played albums not recently added
Most played albums not recently played
Most played albums recently added
Most played albums recently played
Most played artists
Most played artists not recently added
Most played artists not recently played
Most played artists recently added
Most played artists recently played
Most played genres
Most played playlists
Most played songs
Most played songs not recently added
Most played songs not recently played
Most played songs recently added
Most played songs recently played

Most played years
Never played albums
Never played artists
Never played songs
Not completely rated albums
Not completely rated albums not recently added
Not completely rated albums not recently played
Not completely rated albums recently added
Not completely rated albums recently played
Not completely rated artists
Not completely rated artists not recently added
Not completely rated artists not recently played
Not completely rated artists recently added
Not completely rated artists recently played
Not rated albums
Not rated albums not recently added
Not rated albums not recently played
Not rated albums recently added
Not rated albums recently played
Not rated artists
Not rated artists not recently added
Not rated artists not recently played
Not rated artists recently added
Not rated artists recently played
Not rated songs
Not rated songs not recently added
Not rated songs not recently played
Not rated songs recently added
Not rated songs recently played

Partly/Never played albums
Partly/Never played artists
Songs played long ago
Songs rated 1
Songs rated 10
Songs rated 2
Songs rated 3
Songs rated 4
Songs rated 5
Songs rated 6
Songs rated 7
Songs rated 8
Songs rated 9

Top rated albums
Top rated albums not recently added
Top rated albums not recently played
Top rated albums recently added
Top rated albums recently played
Top rated artists
Top rated artists not recently added
Top rated artists not recently played
Top rated artists recently added
Top rated artists recently played
Top rated genres
Top rated playlists
Top rated songs
Top rated songs not recently added
Top rated songs not recently played
Top rated songs recently added
Top rated songs recently played

Top rated years
Morbeas
 
Posts: 245
Joined: Fri Feb 01, 2013 3:07 pm

Re: Database view improvements

Postby musoware » Fri May 04, 2018 7:36 am

I think only those filters relevant to 'songs' are applicable to database view (highlighted), the others may be applicable to the main view.
musoware
Site Admin
 
Posts: 1666
Joined: Fri Sep 14, 2012 6:50 am

Re: Database view improvements

Postby Morbeas » Mon May 14, 2018 10:58 pm

I use ServiceNow for work and as I was running a report today, I thought of muso and how awesome it would be if you could develop a similar interface for generating playlists or just viewing your music library by certain criteria. Basically it's filtering. You can build filters like all songs rated 7 or higher, of rock/metal/pop genres, released after 1990. You can stack many of these and/or statements and build your filter. Every column in the db view would be a field you can filter by. You have the field you're going to filter by, you then apply an operator (is one of, greater/smaller than, contains etc.) and finally you define the value(s).

I have no idea how easily this can be implemented but I wanted to share it with you. :)
Attachments
filter.jpg
Morbeas
 
Posts: 245
Joined: Fri Feb 01, 2013 3:07 pm


Return to Feature Requests

Who is online

Users browsing this forum: No registered users and 0 guests

cron