SQLite still shows data in view after updating to server

I am building an ionic app with ngCordova & SQLite database. I am doing an offline inventory where data gets stored to local database. I have provided a button that sync the local records to server and when response arrived as “succees” i update the active_status of the record to 0 from 1. When all records are sync up with server i refresh the view, but when i refresh the view it still shows me the records their.

NOTE: When i display the view i retrieve records whose sync = 0 using select query.

When i log out close the app and open it again and after login see the history then it does not show me anything. Why this one is happening i am not getting here. Anyone who have faced the problem please provide your views on it.

Thank you very much for your time and any quick views would be appreciated really.