Page 1 of 2 1 2
Reply
Thread Tools
dzano is offline dzano
2013-03-25 , 19:03
Posts: 226 | Thanked: 270 times | Joined on Apr 2012 @ Bosnia and Herzegovina
#1
Hello everyone,

is there any way to show missed call (caller number) in terminal?

Thank you
__________________

-"My Site's Name"-

Another lockscreen weather
Weather widget (HTC icons)
Auto-give a ring (missed call)
 
szopin is offline szopin
2013-03-25 , 19:17
Posts: 2,076 | Thanked: 3,268 times | Joined on Feb 2011
#2
You should be able to find it at the end of ~/.rtcomm-eventlogger/el-v1.db, parsing it to be human readable might be a bit problematic though
 

The Following 3 Users Say Thank You to szopin For This Useful Post:
dzano is offline dzano
2013-03-25 , 19:28
Posts: 226 | Thanked: 270 times | Joined on Apr 2012 @ Bosnia and Herzegovina
#3
I tried it, I found this

Code:
sqlite3 /home/user/.rtcom-eventlogger/el-v1.db "select count(id) from events where event_type_id = 3"
but it doesn't work. Even if it would work, I think it only shows number of missed calls (not caller number)
__________________

-"My Site's Name"-

Another lockscreen weather
Weather widget (HTC icons)
Auto-give a ring (missed call)
 

The Following 2 Users Say Thank You to dzano For This Useful Post:
szopin is offline szopin
2013-03-25 , 19:32
Posts: 2,076 | Thanked: 3,268 times | Joined on Feb 2011
#4
select count(id)
is probably responsible for showing the count, not sure what other options are there
 

The Following 2 Users Say Thank You to szopin For This Useful Post:
szopin is offline szopin
2013-03-25 , 19:40
Posts: 2,076 | Thanked: 3,268 times | Joined on Feb 2011
#5
Code:
sqlite3 /home/user/.rtcom-eventlogger/el-v1.db "select remote_uid from events where event_type_id = 2"
seems to work
 

The Following 3 Users Say Thank You to szopin For This Useful Post:
dzano is offline dzano
2013-03-25 , 19:49
Posts: 226 | Thanked: 270 times | Joined on Apr 2012 @ Bosnia and Herzegovina
#6
THANK YOU! That's it...it shows all missed calls but I will figure out something to use last one. Thanks again.
__________________

-"My Site's Name"-

Another lockscreen weather
Weather widget (HTC icons)
Auto-give a ring (missed call)
 
szopin is offline szopin
2013-03-25 , 19:55
Posts: 2,076 | Thanked: 3,268 times | Joined on Feb 2011
#7
sqlite3 /home/user/.rtcom-eventlogger/el-v1.db "select remote_uid from events where event_type_id = 2" | tail -n 1
 

The Following 3 Users Say Thank You to szopin For This Useful Post:
qwazix's Avatar
qwazix is offline qwazix
2013-03-26 , 07:55
Moderator | Posts: 2,622 | Thanked: 5,447 times | Joined on Jan 2010
#8
Code:
sqlite3 /home/user/.rtcom-eventlogger/el-v1.db "select remote_uid from events where event_type_id = 2 order by desc limit 1"
untested but something along these lines should work
__________________
Proud coding competition 2012 winner: ρcam
My other apps: speedcrunch N9 N900 Jolla –– contactlaunch –– timenow

Nemo UX blog: Grog
My website: qwazix.com
My job: oob
 

The Following 5 Users Say Thank You to qwazix For This Useful Post:
szopin is offline szopin
2013-03-26 , 09:06
Posts: 2,076 | Thanked: 3,268 times | Joined on Feb 2011
#9
Code:
sqlite3 /home/user/.rtcom-eventlogger/el-v1.db "select remote_uid from events where event_type_id = 2 order by id desc limit 1"
 

The Following 3 Users Say Thank You to szopin For This Useful Post:
kraker_abhy is offline kraker_abhy
2013-10-18 , 19:53
Posts: 76 | Thanked: 44 times | Joined on Apr 2011 @ India
#10
Originally Posted by szopin View Post
Code:
sqlite3 /home/user/.rtcom-eventlogger/el-v1.db "select remote_uid from events where event_type_id = 2 order by id desc limit 1"
Thanks for the code but i get this error "SQL error: no such table" events"

Can anyone help with it please?
 
Reply
Page 1 of 2 1 2

Tags
missed call, number, terminal

« Previous Thread | Next Thread »

 
Forum Jump


All times are GMT. The time now is 22:32.

Contact Us - Home - Archive - Top