count missed calls - maemo.org

Active Topics

Camera phone competition March 2023 "Endless" (35)
to General by Maemish - 2 days, 9 hrs ago
TLS 1.2 for N9 is ready (28)
to MeeGo / Harmattan by smartblu9 - 2 days, 11 hrs ago
Maemo repository (3)
to Community by torsen - 3 days, 2 hrs ago
Error after installing Leste on sdcard (11)
to Maemo 7 / Leste by Maemish - 4 days ago
Introducing ubiboot N9 (multiboot OS loader) (1,393)
to Alternatives by smatkovi - 5 days, 6 hrs ago
more...

Thread Tools

b0unc3	2010-03-12 , 12:14
Posts: 318 \| Thanked: 735 times \| Joined on Oct 2009	#1

Hello,

I'm looking on how to get the number of missed calls.
I found this cmd on a thread :

Code:

sqlite3 /home/user/.rtcom-eventlogger/el.db "select count(id) from events where event_type_id = 3"

that is quite good, but it return the count of all the missed calls. I was wondering if there is any way to get the count of the only "current" missed calls (or maybe the only ones that are still notified on the desktop).
Thanks.

Quote & Reply |

The Following User Says Thank You to b0unc3 For This Useful Post:
felbutss

x-lette	2010-03-12 , 12:49
Posts: 539 \| Thanked: 165 times \| Joined on Feb 2010 @ Berlin, Germany	#2

You need to have a timestamp from which you select the missed calls. Within the database there are three timestamps (at least for SMS) which should have more or less the same content. If you frequently miss calls you might try something fixed like "missed calls within the last 24 hours". Or you define a timestamp whenever you ask for missed calls and use this one as reference.

I don't know whether it is possible to select exactly these entries that are displayed on screen. But there also has to be a timestamp for that.

Quote & Reply |

The Following User Says Thank You to x-lette For This Useful Post:
b0unc3

b0unc3	2010-03-12 , 16:09
Posts: 318 \| Thanked: 735 times \| Joined on Oct 2009	#3

Originally Posted by x-lette

You need to have a timestamp from which you select the missed calls. Within the database there are three timestamps (at least for SMS) which should have more or less the same content. If you frequently miss calls you might try something fixed like "missed calls within the last 24 hours". Or you define a timestamp whenever you ask for missed calls and use this one as reference.

I don't know whether it is possible to select exactly these entries that are displayed on screen. But there also has to be a timestamp for that.

Yes , you are right, seems to work fine. (I'm feeling blinded