Search the Community
Showing results for tags 'smart queries'.
Found 1 result
-
In my app New Playlist Manager, I am developing "Smart Playlist" functionality ahainst the Poweramp Media database instead of the Android Media database. Main reason for doing this is that Android does not offer the ratings tags whereas Poweramp does. However I run into the same frsutrating issue when trying to query for Genre. Both Poweramp and Android appear not to adhere to relational database design principles as I am unable to return "genre" within the same query. The table folder_files holds foreign keys to album, artist, composer referring to data held in other tables. Surprisingly the key to genre is missing. There are url's listed in the API documentation but I would like to return all relevant track info in one sql pass, for example: powerampuri = Uri.parse("content://com.maxmpz.audioplayer.data/files"); return resolver.query( powerampuri, new String[]{pamp.pamptrack_id, pamp.folders_path, pamp.folder_files_name}, mwhere, sselectionArgs, msort_order); but as fas as I am able to establish, genre is not included Anyone have any suggestions?
