erland;227225 Wrote: > 2. If you have the Database Query plugin installed, you can create a new > "Free form query" and enter SQL statement like: > > Code: -------------------- > > > select attr,count(*) from customscan_track_attributes where module='mixedtag' group by attr > -------------------- > > > > 3. Connect with a SQL client of your choice towards the MySQL > database and run the same SQL query as in alternative 2 above.
To facilitate testing I've created a much smaller library (5116 tracks) and scanned it. Everything now seems to be working fine and I was able to browse the customscan_track_attributes table using SQLyog and confirm that the STYLE, MOOD & THEME tags have been read and each unique comma separated descriptor for each populated into the table. :) I'm listening to a perpetual singer/songwriter playlist as I type this :) A question to aid my understanding if I may: to benefit most from "Random for mixed tags" playlists I should be creating as many variances as I like and naming and saving them accordingly for reuse whenever the mood strikes me? If I don't select a STYLE/THEME/MOOD to include and/or exclude I presume that the attribute is simply ignored in the construct of the SQL statement - eg if I select only STYLE = Singer/Songwriter and don't select anything in the THEME and MOOD listboxes the resultant SQL statement ignores THEME and MOOD as criteria? -- egd Thecus N5200PRO >> Transporter >> ATC SCA2 >> ATC SCM100SLAT ------------------------------------------------------------------------ egd's Profile: http://forums.slimdevices.com/member.php?userid=3425 View this thread: http://forums.slimdevices.com/showthread.php?t=38256 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
