View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005485 | MMW v4 | Other | public | 2009-04-07 00:37 | 2009-04-09 01:30 |
| Reporter | Bex | Assigned To | |||
| Priority | immediate | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 3.1 | ||||
| Fixed in Version | 3.1 | ||||
| Summary | 0005485: Active filter is incorrectly implemented in the "Artist & Album Artist"-Node | ||||
| Description | The filter-sql is only applied to the Artist and not to the Album Artist thus making the node to only display Artists matching the active filter and not any Album Artists. E.g. Apply "General Music"-Filter It gives this SQL: SELECT Artists.ID, Artists.Artist,Artists.Albums AS cnt FROM Artists WHERE Artists.ID IN (SELECT ArtistsSongs.IDArtist FROM ArtistsSongs WHERE ArtistsSongs.PersonType=1 AND ArtistsSongs.idSong IN (SELECT ID FROM Songs WHERE(Songs.TrackType=0))) GROUP BY Artists.ID, Artists.Artist It should give something like this: SELECT Artists.ID, Artists.Artist,Artists.Albums AS cnt FROM Artists WHERE Artists.ID IN (SELECT ArtistsSongs.IDArtist FROM ArtistsSongs WHERE ArtistsSongs.PersonType=1 AND ArtistsSongs.idSong IN (SELECT ID FROM Songs WHERE(Songs.TrackType=0))) OR Artists.ID IN (SELECT ArtistsAlbums.IDArtist FROM ArtistsAlbums WHERE ArtistsAlbums.IDAlbum IN (SELECT Songs.IDAlbum FROM Songs WHERE (Songs.TrackType=0))) | ||||
| Additional Information | http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=38300 | ||||
| Tags | No tags attached. | ||||
| Fixed in build | 1234 | ||||
