Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 08-13-2013, 11:49 AM   #1
mcam
Member
mcam began at the beginning.
 
Posts: 23
Karma: 10
Join Date: Aug 2013
Device: Kindle
Browsing by Published date

I have a library of monthly publications going back 25 years. Is there a way I can have the tag browser show the year component of the Published Date meta field, so I can jump straight to a specific year and list only the issues of that year?
mcam is offline   Reply With Quote
Old 08-13-2013, 12:00 PM   #2
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,251
Karma: 27110894
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Simply type:

pubdate:=2013

in the search bar, replace 2013 with the year of interest.
kovidgoyal is offline   Reply With Quote
Advert
Old 08-13-2013, 12:05 PM   #3
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,364
Karma: 8012652
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
You can do this by creating a composite custom column (a "column built from other columns", but not "acts like tags"). You would check the box "Show in tag browser". The template would be
Code:
{pubdate:format_date(yyyy)}
You will now have an entry in the tag browser for each publication year.

Do note that composite columns can cause performance problems, especially for very large libraries. Try it and see if the performance is acceptable. If not, then delete the column.
chaley is offline   Reply With Quote
Old 08-13-2013, 12:49 PM   #4
mcam
Member
mcam began at the beginning.
 
Posts: 23
Karma: 10
Join Date: Aug 2013
Device: Kindle
Quote:
Originally Posted by chaley View Post
You can do this by creating a composite custom column (a "column built from other columns", but not "acts like tags"). You would check the box "Show in tag browser". The template would be
Code:
{pubdate:format_date(yyyy)}
You will now have an entry in the tag browser for each publication year.

Do note that composite columns can cause performance problems, especially for very large libraries. Try it and see if the performance is acceptable. If not, then delete the column.
Thanks a bunch, that worked a treat. The library is quite small (12 issues per year x 25 years) so the performance hit is negligible.
mcam is offline   Reply With Quote
Old 08-13-2013, 12:58 PM   #5
mcam
Member
mcam began at the beginning.
 
Posts: 23
Karma: 10
Join Date: Aug 2013
Device: Kindle
Quote:
Originally Posted by kovidgoyal View Post
Simply type:

pubdate:=2013

in the search bar, replace 2013 with the year of interest.
Thanks.
mcam is offline   Reply With Quote
Advert
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Date first published applesauce General Discussions 19 07-16-2013 07:46 AM
'Published date' and 'originally published date' Arrghus Calibre 2 07-29-2011 12:43 AM
Date published philandjan Library Management 1 06-02-2011 11:43 AM
Bulk Changing Published Date To Date hmf Calibre 4 10-19-2010 10:19 PM
Published Date from the file name selfdestroyer Calibre 2 06-16-2010 04:31 AM


All times are GMT -4. The time now is 12:23 PM.


MobileRead.com is a privately owned, operated and funded community.