Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 12-13-2020, 12:07 AM   #1
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 10,969
Karma: 75337983
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Question about column sorting

Currently, I use View Manager to apply this sort on two of my views:

1. Currently Reading #currentlyreading (ascending, psuedobool composite)
2. On Reading List #onreadinglist (ascending, psuedobool composite)
3. Reading List #readorder (ascending, series-like text)
4. Percent Read #percentread (descending, integer)
5. Last Read #lastread (descending, date column)
6. Other sorts here.

Click image for larger version

Name:	2020-12-13 01_12_43-Customize View Manager.png
Views:	97
Size:	50.7 KB
ID:	183969

(note that I use "psuedobool composite" as a term for a composite column that returns "yes" when the criteria matches)

For the most part, it produces the result I want:
1. Books I'm currently reading are at the top. They are sorted in descending order based on what percentage I've read of them.
2. They're then followed by books on the reading list.
3. Then it's followed by all of the 100% read books in order of the last read date.
4. Then it's followed by all the other unread books.

Here's the composites:

#currentlyreading:
Code:
program: 
	test(check_yes_no('#read', 0, 1, 0),  test(field('#lastread'), 'Yes', ''), '')
#onreadinglist (this is just a kludge column to ensure that #readorder sorts to the top when it's in ascending order):
Code:
program: 
	test(field('#readorder'), 'Yes', '')
However, there's one quirk with this: any books that have both #currentlyreading and #readorder sort above the rest, and the sort resets itself with each list:

Click image for larger version

Name:	2020-12-13 00_58_31-calibre.png
Views:	90
Size:	28.2 KB
ID:	183968

Is there any sort of hidden sorting kludge column I can do to make sure them not sort separately when both #currentlyreading and #onreadinglist/#readorder are active?

Last edited by ownedbycats; 12-13-2020 at 12:13 AM.
ownedbycats is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Column: Alphabetical sorting in tag browser includes articles ownedbycats Library Management 2 06-30-2020 12:52 PM
Genre Column and Sorting waynelawson Library Management 4 02-19-2012 12:56 PM
Sorting/searching composite column causes slow startup [solved] capnm Library Management 0 11-08-2011 11:44 AM
Need help sorting the 'on device' column ficbot Calibre 5 04-30-2011 12:04 PM
Question about Column Sorting danwdoo Calibre 8 03-05-2009 11:59 AM


All times are GMT -4. The time now is 04:55 AM.


MobileRead.com is a privately owned, operated and funded community.