• 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 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
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
johanvromans.nl — hetgeluidvanseptember.nl — mojore.nl -- howsagoin.nl
Samsung Galaxy Note S7FE (T733) 12.4", Android 13.0, AirTurn Duo & Digit (Gigs).
Samsung Galaxy Note S4 (T830) 10.5", Android 10.0 (maintenance and backup).
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 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
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
johanvromans.nl — hetgeluidvanseptember.nl — mojore.nl -- howsagoin.nl
Samsung Galaxy Note S7FE (T733) 12.4", Android 13.0, AirTurn Duo & Digit (Gigs).
Samsung Galaxy Note S4 (T830) 10.5", Android 10.0 (maintenance and backup).
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 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
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 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
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 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply




Users browsing this thread:
4 Guest(s)


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