Thread: Received sms/missed call notification
View Single Post
nex is offline nex
2010-02-26 , 19:24
Posts: 61 | Thanked: 13 times | Joined on Jan 2010
#8
You could probably use Desktop Command Execution Widget to display the results of an sqlite command on the desktop:

Code:
sqlite3 /home/user/.rtcom-eventlogger/el.db "select count(id) from events where event_type_id = 7 and is_read=0"
will show you number of unread sms and

Code:
sqlite3 /home/user/.rtcom-eventlogger/el.db "select count(id) from events where event_type_id = 3"
will show you number of missed calls.

Mind you, this isn't the same as number of alerts (what makes the notification light blink). SMSes in particular I mostly see in the task manager and hit X to close them without reading. Those are still unread will be included in the count. I'll look at the specification to see if there's a better way about this.
 

The Following 2 Users Say Thank You to nex For This Useful Post: