Specific search criteria for a Virtual Library

C-novice · 07-09-2018, 08:08 PM

Dear Lord I do hope this makes sense folks.

I've a few Virtual Libraries -one called Wishlist. I add books -really covers only- and the date available to remind me when to purchase them.

They all have different release dates and I'd like to search / organize VL Wishlist by current month and year without organizing my entire Calibre library in that way.

When I set up VL Wishlist I added columns for Start and End read dates; Date Available; Price; Date Purchased etc..

I sort VL Wish List by the Date Available column but can only do so A-Z or Z-A. I'd like to be able to -sort/filter by a specific month and year. Would I use Add Saved Search?
What search expression would I use?

kovidgoyal · 07-09-2018, 09:05 PM

See https://manual.calibre-ebook.com/gui...h-interfacefor the syntax for searching on date like columns

BetterRed · 07-09-2018, 09:37 PM

@C-novice - the Advanced Search tool has a Date Search GUI

Click image for larger version

Name: 2.jpg
Views: 166
Size: 94.4 KB
ID: 164967

BR

C-novice · 07-09-2018, 11:01 PM

@kovid, @BetterRed. Thank you both.

I saw those 2 options but I think this #preorder_dateavailable:=thismonth is the closest to what I needed which is, e.g. 'between July 01, 2018 and July 31, 2018' something just to filter out the specific time frame.

I would just like to write something like 'March 15, 2018 and August 25, 2018' and see the books relevant to those dates.

In any case, Calibre is quite fantastic. Thanks again.

kovidgoyal · 07-09-2018, 11:50 PM

#preorder_dateavailable:>=2018-03-15 and #preorder_dateavailable:<=2018-04-15

C-novice · 07-10-2018, 10:47 PM

Quote:

Originally Posted by kovidgoyal

#preorder_dateavailable:>=2018-03-15 and #preorder_dateavailable:<=2018-04-15

This is perfect. thanks kovid. Now I can make it a saved search and change the criterion as needed.

07-09-2018, 08:08 PM	#1
C-novice ReadingZealot Posts: 164 Karma: 11818 Join Date: Oct 2014 Device: kobo ARC, Samsung Tab4	Specific search criteria for a Virtual Library Dear Lord I do hope this makes sense folks. I've a few Virtual Libraries -one called Wishlist. I add books -really covers only- and the date available to remind me when to purchase them. They all have different release dates and I'd like to search / organize VL Wishlist by current month and year without organizing my entire Calibre library in that way. When I set up VL Wishlist I added columns for Start and End read dates; Date Available; Price; Date Purchased etc.. I sort VL Wish List by the Date Available column but can only do so A-Z or Z-A. I'd like to be able to -sort/filter by a specific month and year. Would I use Add Saved Search? What search expression would I use?

07-09-2018, 09:37 PM	#3
BetterRed null operator (he/him) Posts: 20,590 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	@C-novice - the Advanced Search tool has a Date Search GUI BR

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't search on custom column, multiple criteria	bob.f	Calibre Companion	0	03-19-2018 10:38 AM
Virtual Libraries Search Expressions	gavinjb	Library Management	4	05-18-2014 12:35 PM
Help with custom search to create virtual library	BunnyGal	Library Management	10	01-09-2014 07:56 PM
Developers: Virtual Library vs Saved Search	macnab69	Library Management	7	10-19-2013 01:38 PM
Classic Removing search criteria on softrooted Nook	jjansen	Nook Developer's Corner	3	08-29-2010 04:39 PM

07-09-2018, 09:05 PM	#2
kovidgoyal creator of calibre Posts: 43,871 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	See https://manual.calibre-ebook.com/gui...h-interfacefor the syntax for searching on date like columns

07-09-2018, 11:01 PM	#4
C-novice ReadingZealot Posts: 164 Karma: 11818 Join Date: Oct 2014 Device: kobo ARC, Samsung Tab4	@kovid, @BetterRed. Thank you both. I saw those 2 options but I think this #preorder_dateavailable:=thismonth is the closest to what I needed which is, e.g. 'between July 01, 2018 and July 31, 2018' something just to filter out the specific time frame. I would just like to write something like 'March 15, 2018 and August 25, 2018' and see the books relevant to those dates. In any case, Calibre is quite fantastic. Thanks again.

07-09-2018, 11:50 PM	#5
kovidgoyal creator of calibre Posts: 43,871 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	#preorder_dateavailable:>=2018-03-15 and #preorder_dateavailable:<=2018-04-15

Advert

Advert