What would be the best/correct way do query for

Trel · Yesterday, 03:59 PM

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.

jmurphy · Yesterday, 08:36 PM

It won't get rid of the id, but try:

list --fields series,series_index --search "series:true and series_index:1.0 and #readstatus:Read" --sort-by series --ascending

Yesterday, 03:59 PM	#1
Trel Connoisseur Posts: 61 Karma: 10 Join Date: Jan 2010 Device: Onyx Boox Poke 3	What would be the best/correct way do query for 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. Last edited by Trel; Yesterday at 04:03 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Query re editor	johngross	Editor	0	10-07-2019 04:46 PM
meaning and how to correct	ralphiedee	Sigil	4	10-17-2012 03:48 PM
Metadata query	iain robinson	ePub	4	08-08-2012 12:07 PM
Hello and query	MPDuke	Introduce Yourself	8	12-13-2011 10:27 AM
Query - Kindle DX US	ukhant	Kindle Developer's Corner	2	07-20-2010 03:23 AM

Yesterday, 08:36 PM	#2
jmurphy Connoisseur Posts: 94 Karma: 1133068 Join Date: Sep 2007 Device: ipaq	It won't get rid of the id, but try: list --fields series,series_index --search "series:true and series_index:1.0 and #readstatus:Read" --sort-by series --ascending

Advert