MobileRead Forums - View Single Post - Is it possible to sort kobo collection by series?

Stevex · 11-09-2016, 06:54 PM

If anyone is still interested I posted this before in Series Order thread but again here.

If you don't mind to lose the "recently read" sort order (which I have personally exactly zero use for) you can use this for series order instead by adding the following stored procedures. (The reason for *10 is that I have a few 1.5, 1.7 and suchlike, if you have 1.66 you can always make times and divide by 100 or whatever)

I have to say, it's actually brilliant to see my collections come up spontaneously in the right order without having to mangle titles and suchlike.

One caveat: If you read a book, this will of course become out of order till you restart the machine or similar.

CREATE TRIGGER Activity_Reset_Collection_1 AFTER INSERT ON Activity BEGIN UPDATE Content SET DateLastRead = date((julianday('Now')*10-SeriesNumber*10)/10) WHERE SeriesNumber not null and ContentType=6; END

CREATE TRIGGER Activity_Reset_Collection_2 AFTER UPDATE ON Activity BEGIN UPDATE Content SET DateLastRead = date((julianday('Now')*10-SeriesNumber*10)/10) WHERE SeriesNumber not null and ContentType=6; END

11-09-2016, 06:54 PM	#15
Stevex Addict Posts: 225 Karma: 15318 Join Date: Nov 2015 Device: Kobo Glo HD	If anyone is still interested I posted this before in Series Order thread but again here. If you don't mind to lose the "recently read" sort order (which I have personally exactly zero use for) you can use this for series order instead by adding the following stored procedures. (The reason for 10 is that I have a few 1.5, 1.7 and suchlike, if you have 1.66 you can always make times and divide by 100 or whatever) I have to say, it's actually brilliant to see my collections come up spontaneously in the right order without having to mangle titles and suchlike. One caveat: If you read a book, this will of course become out of order till you restart the machine or similar. CREATE TRIGGER Activity_Reset_Collection_1 AFTER INSERT ON Activity BEGIN UPDATE Content SET DateLastRead = date((julianday('Now')10-SeriesNumber10)/10) WHERE SeriesNumber not null and ContentType=6; END CREATE TRIGGER Activity_Reset_Collection_2 AFTER UPDATE ON Activity BEGIN UPDATE Content SET DateLastRead = date((julianday('Now')10-SeriesNumber*10)/10) WHERE SeriesNumber not null and ContentType=6; END