HowTo? Virtual Library... date="today" (or range)

wjBLqf-_9 · 09-26-2020, 05:16 PM

Is there a way to create a virtual library that shows books matching...
date:"=today"
(variable that matches 'the-day-of-here-and-now' date upon which the query was executed)

what about creating a virtual library that shows books matching...
date:"=past-x-days" <-- would be the past 'x' days including today
date:"=this-year" <-- now would be 2020, after JAN would be 2021
date:"=last-year" <-- now would be 2019, after JAN would be 2020

forgive my silly way of speaking.
I am trying to convey the 'system variable' nature of the queries.

ilovejedd · 09-26-2020, 05:32 PM

First two are easy. The following should work.

date:today
date:<=7daysago

I believe yesterday and thismonth are also supported. Dunno how you’d do the variable year, though.

BetterRed · 09-26-2020, 06:05 PM

@wjBLqf-_9 - the so-called "Advanced Search" tool (gear icon on left hand end of search box) has a Date searches tab that can be useful - not sure if you can get it to do all what you want - but it might give you some clues.

Why 'so-called' because its more like a "Search Helper" Advanced is when you can type a complex search expression containing multiple regex search terms strung together with the 'and's, 'or's, 'not's, '('s, and ')'s where they should be

Don't look at me

BR

theducks · 09-26-2020, 06:22 PM

Here is one I use to see if I need to send (again) to my device : Looks for 2 days

Code:

last_modified:>=2daysago and formats:true

last_modified is a Calibre field that reflects ANY data change for the title.

Any valid search dialog should be good for a VL

ownedbycats · 09-26-2020, 06:33 PM

This is my 'recently added' saved search:

Code:

date:>7daysago

You can also apply this to custom date columns - here's my 'recently updated fanfics' search:

Code:

#fanficupdated:>7daysago AND #fanficstatus:"In-Progress"

Winnito · 11-21-2020, 04:09 PM

What about sorting Virtual library results by a different column than the tab with all books? Let's say I'm looking all the books sorted by author, and then hit my VL tab with recently opened which is set with <last7days....can I automatically sort the results by that same column? tnx

ownedbycats · 11-21-2020, 04:35 PM

Use View Manager.

Winnito · 11-22-2020, 02:53 AM

Quote:

Originally Posted by ownedbycats

Use View Manager.

ok, will check it out. tnx for the tip

dunhill · 11-22-2020, 05:39 PM

And if I wanted to know the books that I have read this month, taking into account that I have a custom column with the finished date, how would the syntax be?
My custom column is named dateendded
And build a virtual library to see the monthly readings with this syntax #dateendded:> 30daysago
How could I see only those of the previous month?
The date is calculated from the day of the date
Therefore, it calculates business days, that is, it does not calculate Sunday.
Solve the formula calculating 34 days

ownedbycats · 11-22-2020, 06:08 PM

Quote:

Originally Posted by dunhill

And if I wanted to know the books that I have read this month, taking into account that I have a custom column with the finished date, how would the syntax be?

#lastread:=thismonth

chaley · 11-22-2020, 06:35 PM

Quote:

Originally Posted by ownedbycats

#lastread:=thismonth

Note that "thismonth" is precisely that, the current month, not the last 30/31 days.

dunhill · 11-22-2020, 06:49 PM

Quote:

Originally Posted by ownedbycats

#lastread:=thismonth

Thank you very much, great.
And previous month

theducks · 11-22-2020, 07:06 PM

use daysago
eg date:>=30daysago

09-26-2020, 05:16 PM	#1
wjBLqf-_9 Connoisseur Posts: 57 Karma: 12544 Join Date: Jul 2018 Device: None	HowTo? Virtual Library... date="today" (or range) Is there a way to create a virtual library that shows books matching... date:"=today" (variable that matches 'the-day-of-here-and-now' date upon which the query was executed) what about creating a virtual library that shows books matching... date:"=past-x-days" <-- would be the past 'x' days including today date:"=this-year" <-- now would be 2020, after JAN would be 2021 date:"=last-year" <-- now would be 2019, after JAN would be 2020 forgive my silly way of speaking. I am trying to convey the 'system variable' nature of the queries.

09-26-2020, 06:22 PM	#4
theducks Well trained by Cats Posts: 31,062 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Here is one I use to see if I need to send (again) to my device : Looks for 2 days Code: last_modified:>=2daysago and formats:true last_modified is a Calibre field that reflects ANY data change for the title. Any valid search dialog should be good for a VL

09-26-2020, 06:33 PM	#5
ownedbycats Custom User Title Posts: 10,974 Karma: 75337983 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	This is my 'recently added' saved search: Code: date:>7daysago You can also apply this to custom date columns - here's my 'recently updated fanfics' search: Code: #fanficupdated:>7daysago AND #fanficstatus:"In-Progress"

11-22-2020, 05:39 PM	#9
dunhill Guru Posts: 893 Karma: 810834 Join Date: Sep 2017 Location: Buenos Aires, Argentina Device: moon+ reader, kindle paperwhite	And if I wanted to know the books that I have read this month, taking into account that I have a custom column with the finished date, how would the syntax be? My custom column is named dateendded And build a virtual library to see the monthly readings with this syntax #dateendded:> 30daysago How could I see only those of the previous month? The date is calculated from the day of the date Therefore, it calculates business days, that is, it does not calculate Sunday. Solve the formula calculating 34 days Attached Thumbnails Last edited by dunhill; 11-22-2020 at 06:44 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating Virtual Library by Publication Date Range	karbonbased	Library Management	1	12-26-2015 03:39 PM
"Virtual" books won't add to calibre library	Tanja1969	Library Management	7	04-09-2015 12:44 AM
FYI: "HowTo" prefix is now called "Tutorial"	ixtab	Kindle Developer's Corner	2	08-15-2013 08:54 AM
Question: addition of "virtual libraries" (was "base search restriction")	chaley	Library Management	53	04-15-2013 12:52 PM
insert "today's date" in regular expression	mark_e_h	Calibre	0	04-07-2012 01:07 PM

09-26-2020, 05:32 PM	#2
ilovejedd hopeless n00b Posts: 5,110 Karma: 19597086 Join Date: Jan 2009 Location: in the middle of nowhere Device: PW4, PW3, Libra H2O, iPad 10.5, iPad 11, iPad 12.9	First two are easy. The following should work. date:today date:<=7daysago I believe yesterday and thismonth are also supported. Dunno how you’d do the variable year, though.

09-26-2020, 06:05 PM	#3
BetterRed null operator (he/him) Posts: 21,725 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	@wjBLqf-_9 - the so-called "Advanced Search" tool (gear icon on left hand end of search box) has a Date searches tab that can be useful - not sure if you can get it to do all what you want - but it might give you some clues. Why 'so-called' because its more like a "Search Helper" Advanced is when you can type a complex search expression containing multiple regex search terms strung together with the 'and's, 'or's, 'not's, '('s, and ')'s where they should be Don't look at me BR

11-21-2020, 04:09 PM	#6
Winnito Enthusiast Posts: 34 Karma: 130226 Join Date: Apr 2020 Device: Kindle Voyage	What about sorting Virtual library results by a different column than the tab with all books? Let's say I'm looking all the books sorted by author, and then hit my VL tab with recently opened which is set with <last7days....can I automatically sort the results by that same column? tnx

11-21-2020, 04:35 PM	#7
ownedbycats Custom User Title Posts: 10,974 Karma: 75337983 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Use View Manager.

11-22-2020, 07:06 PM	#13
theducks Well trained by Cats Posts: 31,062 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	use daysago eg date:>=30daysago

Advert

Advert