DJanGo wrote: > Thats a really hard one... > Because of the DB schema you cant (IMHO) search for a track with two > genres... > In (my) Theorie you need a temp. table filled with Country and that > temp. Table must be checked for a match Genre like Instrumental to get > to your selection. > > btw. i am NOT using SQL Playlist thats why i didnt answered in the first > place
Thanks for replying this time! In addition to all the other problems I mentioned, my first post sounded like I was only interested in solutions that use SQL Playlist. If I understand what you're saying, and I may not, doing what I want with SQL would require at least two steps: first, select for files where genre="Country", then select from files selected the first time for files where genre="Instrumental". I think I've seem some examples of nested SQL queries. Might it be possible to do what I want that way? In other words, instead of storing the results of the first query in a temporary table to be used by the second query, a single query would first select for Country, then a subquery would operate on that selection to find Instrumental files. (Remember, I am very much a novice at SQL, so there's much I do not understand and my concepts are shaky. I will not be terribly shocked if that turns out not to be possible.) > Originally Posted by dolodobendan View Post > Don't overthink it. > > While I do follow a different approach (Custom Scan, Custom Browse & > Multi Library), I think what you're trying to achieve might be possible > with the "Sub-Library Demo" Plugin and some tinkering. > Sorry, overthinking is what I do! Except when I blunder headlong into something without thinking, I mean. I hadn't considered virtual libraries as a way to do this, but what I see so far looks very encouraging. If I understand at all, I could create a virtual library containing all the Vocal tracks, and another with all the Instrumental tracks. Then it would be straightforward to select for genre within those libraries, to create a playlist with, say, all Country AND Instrumental tracks. Just to complicate matters, would it also be possible to combine tracks from different virtual libraries in a single playlist? As with the example in my second post, could I build a playlist containing all Country OR Rock tracks from the Instrumental library, along with all Jazz OR Rock tracks from the Vocal library? Thanks for the input so far, which has given me a lot to work with. I do not necessarily expect answer to the questions I've asked in this post, as I'll probably be able to find the answers on my own, eventually. (But clarification is always welcome, if either of you -- or anyone else -- is willing to provide it!) I think there's plenty of discussion of virtual libraries for me to dig through. If I go that route, I'll try to find my answers there and only return to this thread to beg for more help when I feel hopelessly stuck. ------------------------------------------------------------------------ RobbH's Profile: http://forums.slimdevices.com/member.php?userid=67008 View this thread: http://forums.slimdevices.com/showthread.php?t=109818 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
