maemo.org - Talk - View Single Post - Missed call (caller number) in terminal?

Ilew	2013-10-18 , 22:22
Posts: 75 \| Thanked: 269 times \| Joined on Aug 2012	#11

Originally Posted by kraker_abhy

Thanks for the code but i get this error "SQL error: no such table" events"

Can anyone help with it please?

Does the db file exist in "/home/user/.rtcom-eventlogger/el-v1.db" ?

Btw expanding upon the previous sql.
This will get the last 5 missed calls and when they tried to call.

Code:

sqlite3 /home/user/.rtcom-eventlogger/el-v1.db "select datetime(start_time, 'unixepoch'), remote_uid from events where event_type_id = 2 order by id desc limit 5"

Quote & Reply |

The Following User Says Thank You to Ilew For This Useful Post:
foobar