I have a custom read/unread column.
I'm aware of calibredb, but not very familiar with it.
What I tried to do was
Code:
calibredb --library-path=/path/to/library list --fields "series,series_index" --search 'series:True series_index:1.0 #readstatus:"=Read"' --sort-by 'series'
I got it mostly working, but three issues.
1. The sort is reverse alphabetical (I want alphabetical)
2. The sort is done where "insignificant" words like "A" or "The" are disregarded (I want them included)
3. It still prints the ID, despite me not including it in --fields (I don't want the ID shown).
I was able to handle this with a mixture of various Linux text processing tools like cut, sed, and sort, but ideally I wouldn't have to do this somehow?
Once I get that down, I want to additionally select the MAX series index for each series, but I have no clue how I'd do that.