MobileRead Forums - View Single Post - Aura HD How to delete old Collections stored in Kobo account?

PeterT · 12-27-2014, 09:55 AM

The gist of the SQL you want to use is:

Code:

  UPDATE Shelf SET _IsDeleted = 'true', 
               LastModified = <timestamp> 
  WHERE _IsSynced = 'true'

You might want to try using a tool like DBeaver or the SQLite Manager for FireFox

12-27-2014, 09:55 AM	#5
PeterT Grand Sorcerer Posts: 13,572 Karma: 79436804 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	The gist of the SQL you want to use is: Code: UPDATE Shelf SET _IsDeleted = 'true', LastModified = <timestamp> WHERE _IsSynced = 'true' You might want to try using a tool like DBeaver or the SQLite Manager for FireFox