• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Filter for notes and annotations
#1
I would like to find easily songs that have notes or annotations. Adding filter options to "additional filters" similar to the filter for songs with audio files would be great.
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1803
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#2
sqlite3 mobilesheets.db 'SELECT DISTINCT Songs.Id,Title,Path FROM Songs,Files,AnnotationsBase WHERE Songs.Id = AnnotationsBase.SongId AND Songs.Id = Files.SongId;'
Johan
www.johanvromans.nlwww.hetgeluidvanseptember.nlwww.howsagoin.nl
Samsung Galaxy Note S4 (T830) 10.5", Android 10.0, AirTurn Duo & Digit.
Samsung A3 (A320FL), Android 8.0.0 (emergency).
Reply
#3
Can you recommend a database tool for Android?
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1803
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#4
Being an open source advocate I'd suggest aSQLiteManager. It does a decent job.
I must add that although I'm a database expert, I never operate on a production database. I always make a copy first. This is expecially necessary when working with SQLite databases since SQLite does not have something similar to readonly access.

(I make automatic copies of the (Android) database to my (Linux) desktop, so I always have a copy at hand to play with.)
Johan
www.johanvromans.nlwww.hetgeluidvanseptember.nlwww.howsagoin.nl
Samsung Galaxy Note S4 (T830) 10.5", Android 10.0, AirTurn Duo & Digit.
Samsung A3 (A320FL), Android 8.0.0 (emergency).
Reply
#5
Thanks for your reply. Just wanted to post the same. I found aSQLiteManager last night and gave it a try on my way to work: it really does a nice job.
https://play.google.com/store/apps/detai...itemanager
My copy of mobilesheets.db has to be on SD0, on SD1 I had a (not fully correct) error message "mobilesheets.db is not a database" - the everlasting Android hassle with SD1 and access rights again.
And YES, I made a copy first, I'm in IT too.
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1803
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#6
Accessing mobilesheets.db via SQL directly is great and offers a lot of new possibilities. But it's not a complete replacement for the comfort and conveniency of having such a filter integrated into MSP. I propose adding it to the "Additional Filters" dialog.
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1803
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#7
Alright, I added an issue for this in bugzilla so that I remember to make the change when time allows.

Thanks,
Mike
Reply
#8
Great. Thank you.
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1803
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.