Active Topics
-
Is there a section to talk about Java ME? Apps, etc. (7)
to General by teroyk - 22 hrs, 48 mins ago - more...
| The Following User Says Thank You to For This Useful Post: | ||
 |
|
2011-07-22
, 19:38
|
|
Posts: 1,918 |
Thanked: 3,118 times |
Joined on Oct 2010
@ My pants
|
#2
|
Originally Posted by geekgirl74
What if I'm not a specialist database programmer? Can I help
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.
?Code:
sqlite3 /home/user/.rtcom-eventlogger/el.db "select count(id) from events where event_type_id = 7 and is_read=0"
Code:
sqlite3 /home/user/.rtcom-eventlogger/el.db "select count(id) from events where event_type_id = 3"
__________________
[NITDroid] [My Qtlockscreen Skins] [QBW HTC Sense on Your N900!] [CPU Power Control] [Debian Packaging] [Build Me!]
Youtube Channel - Subscribe!
Retired Dev - Thanks for all the fish!
[NITDroid] [My Qtlockscreen Skins] [QBW HTC Sense on Your N900!] [CPU Power Control] [Debian Packaging] [Build Me!]
Youtube Channel - Subscribe!
Retired Dev - Thanks for all the fish!
Last edited by ammyt; 2011-07-22 at 19:43.
| The Following 6 Users Say Thank You to ammyt For This Useful Post: | ||
|
|
2011-07-22
, 19:43
|
|
Guest |
Posts: n/a |
Thanked: 0 times |
Joined on
|
#3
|
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
Last edited by geekgirl74; 2011-07-22 at 19:56.
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
Last edited by geekgirl74; 2011-07-22 at 19:56.
| The Following 2 Users Say Thank You to For This Useful Post: | ||
|
|
2011-07-22
, 23:59
|
|
Guest |
Posts: n/a |
Thanked: 0 times |
Joined on
|
#4
|
well, I found it... it's a little different from what you directed me 
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
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
 |
|
2011-07-23
, 06:14
|
|
Posts: 1,444 |
Thanked: 461 times |
Joined on Dec 2010
@ pakistan
|
#5
|
so is it a widget yet or you are still using the command to run it ?
| The Following User Says Thank You to eefo For This Useful Post: | ||
|
|
2011-07-23
, 10:58
|
|
Guest |
Posts: n/a |
Thanked: 0 times |
Joined on
|
#6
|
I'm actually using the "Desktop Command Execution Widget".
This is the result (just look at the top left and top right application icon):
The number is updated whenever I receive new mail or message...
This is the result (just look at the top left and top right application icon):
The number is updated whenever I receive new mail or message...
|
|
2011-07-23
, 11:54
|
|
Posts: 1,444 |
Thanked: 461 times |
Joined on Dec 2010
@ pakistan
|
#7
|
Originally Posted by geekgirl74
nice one .
I'm actually using the "Desktop Command Execution Widget".
This is the result (just look at the top left and top right application icon):
The number is updated whenever I receive new mail or message...
and what about for the missed calls ?
| The Following 2 Users Say Thank You to eefo For This Useful Post: | ||
|
|
2011-07-23
, 11:59
|
|
Guest |
Posts: n/a |
Thanked: 0 times |
Joined on
|
#8
|
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...)
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...)
|
|
2011-07-23
, 12:03
|
|
Posts: 1,444 |
Thanked: 461 times |
Joined on Dec 2010
@ pakistan
|
#9
|
Originally Posted by geekgirl74
lol yes .
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...)
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 ?
| The Following User Says Thank You to eefo For This Useful Post: | ||
|
|
2011-07-23
, 12:16
|
|
Guest |
Posts: n/a |
Thanked: 0 times |
Joined on
|
#10
|
Originally Posted by eefo
yes, the missed calls command works great
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 ?
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.
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.
Last edited by geekgirl74; 2011-07-23 at 00:00.