Reply to thread

Message

<blockquote data-quote="Lyxalig" data-source="post: 70194" data-attributes="member: 11286">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[code]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 FROMsong,album,artist,genre,pathWHEREsong.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 == 1AND idArtist IN&nbsp;&nbsp; (SELECT idArtist&nbsp;&nbsp; FROM song&nbsp;&nbsp; GROUP BY idArtist&nbsp;&nbsp; HAVING COUNT(*) &gt;=7)) (here stops MY sql)GROUP BY &quot;something&quot; ORDER BY &quot;something&quot;[/code]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.. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin&nbsp; &nbsp; :D" loading="lazy" data-shortname=":D" /></blockquote>

[QUOTE="Lyxalig, post: 70194, member: 11286"] 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 [code] 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"[/code] [b]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.[/b] AND almost forgot RESPECT.. :D [/QUOTE]

Verification