[SOLVED][QUESTION] to all programmers and database specialists...
 

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.

Re: [QUESTION] to all programmers and database specialists...
 

What if I'm not a specialist database programmer? Can I help :p?
Shows the number of unread SMSes

Shows the number of missed calls

Re: [QUESTION] to all programmers and database specialists...
 

That's great, thank you :)
But it shows this message:

Nokia-N900:/home/user# sqlite3 /home/user/.rtcom-eventlogger/el.db "select count(id) from events where event_type_id = 7 and is_read=0"
SQL error: no such table: events

Am I missing something?

EDIT: this seems to work, when I use el-v1.db instead, but that file is 2 days old on my system and doesn't contain my test mail... el.db is a 0-sized file :(

Re: [QUESTION] to all programmers and database specialists...
 

well, I found it... it's a little different from what you directed me :D

For SMS:
Nokia-N900:~$ sqlite3 /home/user/.config/hildon-desktop/notifications.db "select count(id) from notifications where icon_name='general_sms'"
1

For Mails:
Nokia-N900:~$ sqlite3 /home/user/.config/hildon-desktop/notifications.db "select count(id) from notifications where icon_name='qgn_list_messagin'"
1

1 was the result, I had one mail and one sms, both unread :)

Re: [SOLVED][QUESTION] to all programmers and database specialists...
 

so is it a widget yet or you are still using the command to run it ?

Re: [SOLVED][QUESTION] to all programmers and database specialists...
 

I'm actually using the "Desktop Command Execution Widget".
This is the result (just look at the top left and top right application icon):
http://img837.imageshack.us/img837/5/screenshot28da.png
The number is updated whenever I receive new mail or message...

Re: [SOLVED][QUESTION] to all programmers and database specialists...
 

nice one .
and what about for the missed calls ?

Re: [SOLVED][QUESTION] to all programmers and database specialists...
 

thx :)
the missed calls number is not yet realized, cause I'm not sure about how I want the info to be displayed (note: there's still the "Phone" button on the dock...)

Re: [SOLVED][QUESTION] to all programmers and database specialists...
 

lol yes .
but does that command which ammyt shared for the missed calls work ?

and yeah little thing :$
what are the update setting of your sms widget ?

Re: [SOLVED][QUESTION] to all programmers and database specialists...
 

yes, the missed calls command works great :) have to admit that I wasn't interested that much in the number of missed calls but in the number of received mails/messages... thanks to ammyt and after some further research I found out how to query at least these basic things ;)
right now the update interval for the sms/im widget is 1 min.