search

andreas-mausch / whatsapp-viewer

Small tool to display chats from the Android msgstore.db database (crypt12)
https://andreas-mausch.de/whatsapp-viewer/
MIT License
1.23k stars 381 forks source link

SQL Instruction? #97

Closed joaoguariglia closed 3 years ago

joaoguariglia commented 4 years ago

I would like to know how you called the msgstore database filters containing and concatenating only the number sent or received and the message, because when I enter the database with the DB Browser tool it is a mess, what would be the SQL statement to appear only the user who sent or received the message and the message as you did in your program?

andreas-mausch commented 4 years ago

You can find the queries here:

https://github.com/andreas-mausch/whatsapp-viewer/blob/2b4e727dfba3ad7847a13588854364ca97e4725b/source/WhatsApp/Database.cpp