View Single Post
Old 05-07-2010, 04:39 PM   #22
darkadept
Member
darkadept began at the beginning.
 
Posts: 18
Karma: 10
Join Date: May 2010
Device: Kobo eReader
Quote:
Originally Posted by PeterT View Post
I removed a lot of stuff from the "I'm Reading" view by the following SQL

Code:
update content 
     set readstatus = 2 
where 
     ReadStatus = 0 and 
     Publisher = 'Gutenberg' and 
     booktitle is null
It's still all on the Kobe; just now marked as finished.
If the readstatus is 0 you just need to set FirstTimeReading to true.
I'm not sure why they use both ReadStatus and FirstTimeReading but they do.

You can try queries like this:
Code:
UPDATE content SET ReadStatus=0, FirstTimeReading='True'
WHERE BookTitle is NULL and Title like '%A Book Title%'
Just replace A Book Title with the title of your book. The percent signs act as wildcards. You can remove them as you wish.

This will set the book as completely unread and new to the kobo.
darkadept is offline   Reply With Quote