Find books in library using regex search

mezme · 10-08-2012, 01:05 AM

I was wondering if one of our resident regex guru's might can help me...

I use the rating field to indicate read or unread books. 3 is unread and 5 is read. I am wanting to do a search and locate all series that have books marked with a 3 and a 5 in it.

I know how to do simple searches like (series:true rating:5) to find all books with a series and a rating of 5... but not how to find all books with a series that have books with a 5 and a 3 rating.

For example I want it to...:

It would find:
rating:3 Author Name - Series Name - Title
rating:3 Author Name - Series Name - Title
rating:5 Author Name - Series Name - Title
rating:5 Author Name - Series Name - Title

It would not find:
rating:5 Author Name - Series Name - Title
rating:5 Author Name - Series Name - Title
rating:5 Author Name - Series Name - Title

and it would not find:
rating:3 Author Name - Series Name - Title
rating:3 Author Name - Series Name - Title
rating:3 Author Name - Series Name - Title

Anyway... help anyone?
Mezme

davidfor · 10-08-2012, 01:47 AM

I think you want:

series:true ( rating:3 or rating:5)

PeterT · 10-08-2012, 08:43 AM

@Davidfor; mezme is looking for a far more complicated search, one that I don't think can be done.

The request is for a search that will find a series that is PARTIALLY read; ie a series that contains BOTH ratings 3 AND 5.

kovidgoyal · 10-08-2012, 08:49 AM

Search operates on a per book level, therefore it is not possible to make a query about objects that are not books, like series or authors.

One thing that might help in your particular case is to sort the Tag Browser by average rating, then look at the list of series in the Tag Browser (if you enable grouping you should have a group of read searies and a group of unread series and a group of partial series).

davidfor · 10-08-2012, 07:13 PM

Quote:

Originally Posted by PeterT

@Davidfor; mezme is looking for a far more complicated search, one that I don't think can be done.

The request is for a search that will find a series that is PARTIALLY read; ie a series that contains BOTH ratings 3 AND 5.

Well, yes, if you want to read ALL the words in the post and pay attention to ALL of them.

And I knew my answer was to simple.

mezme · 12-23-2012, 01:10 AM

I was hoping... but

What I was looking for was a search that would do the following:
Book A Series A Rating 5
Book B Series A Rating 3
Book C Series A Rating 3

So that I could easily find series that I have read (marked with a 5) and have added a new book to but haven't yet read (marked with a 3).

I was thinking it would be too complicated for a regex search but figured it was worth asking.

speakingtohe · 12-23-2012, 01:29 AM

Probably not what you want but I use Alt+A and Alt+Shift+S a lot to get books in same series or by same author. Faster than tag browser for me.

Helen

10-08-2012, 01:05 AM	#1
mezme Connoisseur Posts: 59 Karma: 10 Join Date: Dec 2009 Device: PRS700	Find books in library using regex search I was wondering if one of our resident regex guru's might can help me... I use the rating field to indicate read or unread books. 3 is unread and 5 is read. I am wanting to do a search and locate all series that have books marked with a 3 and a 5 in it. I know how to do simple searches like (series:true rating:5) to find all books with a series and a rating of 5... but not how to find all books with a series that have books with a 5 and a 3 rating. For example I want it to...: It would find: rating:3 Author Name - Series Name - Title rating:3 Author Name - Series Name - Title rating:5 Author Name - Series Name - Title rating:5 Author Name - Series Name - Title It would not find: rating:5 Author Name - Series Name - Title rating:5 Author Name - Series Name - Title rating:5 Author Name - Series Name - Title and it would not find: rating:3 Author Name - Series Name - Title rating:3 Author Name - Series Name - Title rating:3 Author Name - Series Name - Title Anyway... help anyone? Mezme

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Odyssey How to search/find books on Odyssey?	slowfax	Bookeen	6	12-06-2013 12:22 PM
using search/GET BOOKS can I find books I haven't got?	johnwhelan	Calibre	7	06-03-2012 01:53 PM
How to find, in library, books similar to one on device?	capnm	Library Management	1	11-23-2011 06:24 PM
Strange - Annotations disappeared, library and calibre find no books	samysam	Sony Reader	1	12-08-2010 05:31 AM
Regex search author field to locate books?	Starson17	Calibre	2	12-21-2009 10:40 AM

10-08-2012, 01:47 AM	#2
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	I think you want: series:true ( rating:3 or rating:5)

10-08-2012, 08:43 AM	#3
PeterT Grand Sorcerer Posts: 13,693 Karma: 79983758 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	@Davidfor; mezme is looking for a far more complicated search, one that I don't think can be done. The request is for a search that will find a series that is PARTIALLY read; ie a series that contains BOTH ratings 3 AND 5.

10-08-2012, 08:49 AM	#4
kovidgoyal creator of calibre Posts: 45,604 Karma: 28548974 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Search operates on a per book level, therefore it is not possible to make a query about objects that are not books, like series or authors. One thing that might help in your particular case is to sort the Tag Browser by average rating, then look at the list of series in the Tag Browser (if you enable grouping you should have a group of read searies and a group of unread series and a group of partial series).

12-23-2012, 01:10 AM	#6
mezme Connoisseur Posts: 59 Karma: 10 Join Date: Dec 2009 Device: PRS700	I was hoping... but What I was looking for was a search that would do the following: Book A Series A Rating 5 Book B Series A Rating 3 Book C Series A Rating 3 So that I could easily find series that I have read (marked with a 5) and have added a new book to but haven't yet read (marked with a 3). I was thinking it would be too complicated for a regex search but figured it was worth asking.

12-23-2012, 01:29 AM	#7
speakingtohe Wizard Posts: 4,812 Karma: 26912940 Join Date: Apr 2010 Device: sony PRS-T1 and T3, Kobo Mini and Aura HD, Tablet	Probably not what you want but I use Alt+A and Alt+Shift+S a lot to get books in same series or by same author. Faster than tag browser for me. Helen