RobbH wrote: > Thanks to all who have read my post! With well over a hundred views and > no responses, I suspect my question is just too obscure. Maybe nobody > has tried to do this before. > > But it has occurred to me that there might be other reasons for the lack > of response: > > 1. Maybe I did not describe the problem well enough, so nobody > understands what I'm trying to do. I will try to remedy that with a > clearer description below. Or, > > 2. in the first post, I mentioned a genre tag that uses a medieval > ecclesiastical abbreviation for Christmas. Some people find that > abbreviation offensive. So it might be that I have offended someone, and > of course they would feel reluctant to help me. I apologize for any > offense I gave, and I have edited the first post to remove the possibly > offensive word. Or, > > 3. somebody might have experience with this very issue, but suspect that > I am unwilling to do my own work, and thus be reluctant to help me out. > If so, I understand that position. I'll be grateful for any advice that > helps to steer me in the right direction, and I do not necessarily > expect anyone to hand me a fully worked-out solution. Or, > > 4. I might have doomed my chances by failing to specify that I am using > SQLite 1.34_01 (sqlite 3.7.7.1). > > With that out of the way, here's my second attempt to describe the > situation: > > In brief, it is possible to have multiple genre tags in a single file. > And it's easy to select music on the basis of any single tag contained > in the files. Is it possible (using SQL Playlist or any other software > that works with LMS) to select music on the basis that the files must > contain two (or more) specific genre tags? > > Here's a more detailed description with examples: > > Let's say that I have a thousand music files. Every one of those files > has at least one of the following genre tags: Country, Jazz, or Rock. > Each file also contains one of these genre tags: Instrumental or Vocal. > > It's very easy to set up a dynamic playlist that will play all Jazz > files, for instance, regardless of whether they are Vocal or > Instrumental. It's also easy to play all Vocal files, regardless of > whether they are Country, Jazz, or Rock. > > But is it possible to play only files that have both Country and > Instrumental tags? Using the predefined options in SQL playlist, it's > easy to select both those tags, but only with an "OR" Boolean > relationship: files played will either be Country (vocal or > instrumental) or they will be Instrumental (country, jazz or rock). > > Note that there is an easy workaround for this simple case, using the > predefined options: just select to play Country files, then select to > exclude all Vocal files. But that's as far as the predefined options can > go. > > What I want to do is more complex, selecting files on the basis of > multiple options, like this: > > (Country AND Instrumental) OR (Jazz AND Vocal) OR Rock > > Does anyone know if this sort of selection is possible? Obviously, it > can not be done with the predefined options in SQL Playlist. So it will > have to be done by constructing an SQL query. I'm a rank beginner at > that task, but I am hoping to learn. Any advice will be appreciated, > even a gentle nudge in the right direction. And again, if I would be > better off using something other than the SQL Playlist plugin, that > would be very helpful to know. > > Thanks to anyone who reads all the way through this!
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. QLMS [email protected] x64 (digimaster) / QNAP 469L QTS 4.3.4 ------------------------------------------------------------------------ dolodobendan's Profile: http://forums.slimdevices.com/member.php?userid=67663 View this thread: http://forums.slimdevices.com/showthread.php?t=109818 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
