working on: filter in music views reloaded (2 Viewers)

[Lyxalig]

To refrase the horrible last-post :lol: :

Will I be able to make a simple sql-statement that filters down to the songs I would like to get viewed BEFORE the current logic?

Ex: Album- SingleArtist view

SELECT album.idAlbum,album.strAlbum,artist.idArtist,artist.strArtist,song.idSong,
song.strTitle,genre.idGenre,genre.strGenre,song.iTrack,song.iDuration,
song.iYear,song.iTimesPlayed,song.iRating,song.favorite,path.strPath,
song.strFileName 

FROM
song,album,artist,genre,path

WHERE
song.idAlbum = album.idAlbum and song.idArtist = artist.idArtist and song.idGenre = genre.idGenre and song.idPath = path.idPath

(here starts MY sql)
AND album.inumArtists == 1
AND idArtist IN
   (SELECT idArtist
   FROM song
   GROUP BY idArtist
   HAVING COUNT(*) >=7)) 
(here stops MY sql)

GROUP BY 
"something" 

ORDER BY 
"something"

EDIT:
---BAHH--- You got it the first time.. BTW: This feature would be awsome.
Would there be a good idea to store views seperately so that they could be shared?? Maybe put as an xml-file in a seperate folder. this way users could create POWER-views and share them.

AND almost forgot RESPECT..

 

[rtv]

Did you notice any speedups due to your work?

Especially MP's handling of maaany files needs some improvement..

 

[JulianBuss]

yes, from my experiences with my collection (~6000 songs) it's faster.
Unfortunately I cannot finish my modification because I get no answer to this post: https://forum.team-mediaportal.com/showthread.php?t=9926

You are experienced in modifying the confguration GUI, are you? Perhaps you can create a simple text field in the music views section for entering a filter string?

 

[Lyxalig]

Please answer this guy

There must be someone that know the answer to JulianBuss question?
This would be great addition to MP. Please continue your work

 

[rtv]

Sorry, I'm also waiting for Bavarian or someone other to ask..

 

[JulianBuss]

thanks rtv - I'm going on vacation for about two weeks starting tomorrow. Shall I create a patch with the code I have, or is it better to wait until someone implemented the filter text field in the configuration program?