asked 2020-04-09 16:34:44 +0200
Hi there. Any ideas how can I read last sms from specific sender? I searched around and found: https://sailfishos.org/wiki/Messaging#Messaging https://sailfishos.org/wiki/Telepathy_Framework https://git.merproject.org/mer-core/telepathy-ring
But that's it... I was hoping someone already played with this or is more keen with this then me.
answered 2020-04-09 17:31:49 +0200
/home/nemo/.local/share/commhistory/commhistory.db is the sqlite database where all sort of messages are stored.
Then you can list all SMS messages with:
sqlite3 /home/nemo/.local/share/commhistory/commhistory.db "select remoteUid, freeText from events order by starttime desc limit 15"
or filter it by phone number and get the last one:
sqlite3 /home/nemo/.local/share/commhistory/commhistory.db "select freeText from events where remoteUid='+111111111' order by starttime desc limit 1"
answered 2020-04-09 17:33:03 +0200
For debugging purpose, you can inspect the commhistory database. It contains all the SMS : sqlite3 ~/.local/share/commhistory/commhistory.db Then select freeText from events where remoteUid like "%the phone number or part of it%" order by rowid desc limit 1;. You can inspect the schema of the events table to see if you are interested into more fields than freeText: .schema events.
You can run this in one line to make it as a script if you need to also.
answered 2020-04-09 23:21:35 +0200
Not a ssh solution, but from time to time I use a silly solution: 1. Type whatever to that contact as new message. 2. Dont send the message, go „gesture” back to Messages. 3. Your „draft” message is on top, you can check latest messages easy. :)
Would love searching in SMS.
Asked: 2020-04-09 16:34:44 +0200
Seen: 227 times
Last updated: Apr 09 '20