maemo.org - Talk

maemo.org - Talk (https://talk.maemo.org/index.php)
-   Development (https://talk.maemo.org/forumdisplay.php?f=13)
-   -   count missed calls (https://talk.maemo.org/showthread.php?t=47208)

b0unc3 2010-03-12 12:14
count missed calls
 
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.

x-lette 2010-03-12 12:49
Re: count missed calls
 
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.

b0unc3 2010-03-12 16:09
Re: count missed calls
 
Quote:
Originally Posted by x-lette (Post 564990)
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 :))
Thanks!


All times are GMT. The time now is 14:54.

vBulletin® Version 3.8.8