View Single Post
ammyt's Avatar
Posts: 1,918 | Thanked: 3,118 times | Joined on Oct 2010 @ My pants
#2
Originally Posted by geekgirl74 View Post
Hi,

I wonder if it is possible to show the number of unread messages and calls via a certain command in desktop command execution widget? All I've managed to find out is that the information seems to be stored in /home/user/.config/hildon-desktop/notifications.db. How could I query it via commandline? I'm dreaming of placing tiny widgets besides my application icons, for example the number of unread emails close to the icon for modest.

Thanks in advance and sorry if I've overlooked an existing thread.
Cheers.
What if I'm not a specialist database programmer? Can I help ?
Code:
sqlite3 /home/user/.rtcom-eventlogger/el.db "select count(id) from events where event_type_id = 7 and is_read=0"
Shows the number of unread SMSes

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

Last edited by ammyt; 2011-07-22 at 19:43.
 

The Following 6 Users Say Thank You to ammyt For This Useful Post: