Register Guidelines E-Books Search Today's Posts Mark Forums Read

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

Notices

Reply
 
Thread Tools Search this Thread
Old 08-13-2013, 03:14 PM   #1
mcam
Member
mcam began at the beginning.
 
Posts: 12
Karma: 10
Join Date: Aug 2013
Device: Kindle
Sorting tag values in tag browser

Is there a way to sort the values of a tag in the tag browser in descending order?
mcam is offline   Reply With Quote
Old 08-13-2013, 08:05 PM   #2
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 19,570
Karma: 33152421
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
At the bottom of the tag browser, there is a button labelled "Alter Tag Browser". Pressing that displays a menu which includes sort options. Is that what you want?
davidfor is offline   Reply With Quote
Advert
Old 08-14-2013, 01:23 AM   #3
mcam
Member
mcam began at the beginning.
 
Posts: 12
Karma: 10
Join Date: Aug 2013
Device: Kindle
Quote:
Originally Posted by davidfor View Post
At the bottom of the tag browser, there is a button labelled "Alter Tag Browser". Pressing that displays a menu which includes sort options. Is that what you want?
Thanks for your suggestion, but no, that option only determines WHAT the values are sorted on, not whether they are sorted in ascending or descending order.

Last edited by mcam; 08-14-2013 at 01:26 AM.
mcam is offline   Reply With Quote
Old 08-14-2013, 02:20 AM   #4
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 19,570
Karma: 33152421
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Your right. I read your post as "how do I sort". I don't see how to do it either. I would suggest making an enhancement request to reverse the sort when selecting the same one again.
davidfor is offline   Reply With Quote
Old 08-14-2013, 03:06 AM   #5
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: 37,268
Karma: 16447605
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
I dont see a use case for reversing the order, simply scroll upwards instead of downwards if you want to view items in descending order.
kovidgoyal is offline   Reply With Quote
Advert
Old 08-14-2013, 03:36 PM   #6
mcam
Member
mcam began at the beginning.
 
Posts: 12
Karma: 10
Join Date: Aug 2013
Device: Kindle
Quote:
Originally Posted by kovidgoyal View Post
I dont see a use case for reversing the order, simply scroll upwards instead of downwards if you want to view items in descending order.
Yes I agree,there isn't much point in having textual tags sorted in descending order, but my tag is year of publication, and I want to have the most recent editions appear at the top of the list.
mcam is offline   Reply With Quote
Old 08-18-2013, 06:45 AM   #7
GrompyOldMan
Junior Member
GrompyOldMan began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Mar 2012
Device: nook
Click the column header.
GrompyOldMan is offline   Reply With Quote
Old 08-18-2013, 09:20 AM   #8
mcam
Member
mcam began at the beginning.
 
Posts: 12
Karma: 10
Join Date: Aug 2013
Device: Kindle
There is no column header in the tag browser ...
mcam is offline   Reply With Quote
Old 08-23-2013, 06:46 AM   #9
GrompyOldMan
Junior Member
GrompyOldMan began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Mar 2012
Device: nook
Tags column. KISS principle works here.
GrompyOldMan is offline   Reply With Quote
Old 08-23-2013, 12:29 PM   #10
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 16,322
Karma: 19147306
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Why not use built in Published date column rather than a tag

Tweak Control how dates are displayed will allow you to specify display format, default is MMM yyyy (eg Aug 2013), change it to yyyy if that's what you need.

Dates can be sorted in ascending or descending order

BR
BetterRed is offline   Reply With Quote
Old 08-24-2013, 05:06 PM   #11
mcam
Member
mcam began at the beginning.
 
Posts: 12
Karma: 10
Join Date: Aug 2013
Device: Kindle
Thanks BetterRed. I already have a Published column of course (the tag is actually the year component of the Published date), and sorting on that helps, but the tag value allows me to quickly filter by year of publication, and if possible I'd like to have the most recent years at the top of the list for easier accessibility. Still, it's apparently not possible with Calibre as of v.1.0, so that's that.
mcam is offline   Reply With Quote
Old 08-24-2013, 08:15 PM   #12
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 16,322
Karma: 19147306
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by mcam View Post
Thanks BetterRed. I already have a Published column of course (the tag is actually the year component of the Published date), and sorting on that helps, but the tag value allows me to quickly filter by year of publication, and if possible I'd like to have the most recent years at the top of the list for easier accessibility. Still, it's apparently not possible with Calibre as of v.1.0, so that's that.
Maybe someone can come up with another way to do the 'quick filtering' on the pubdate

My first thought is that date column headings would have context menu something like

Code:
Filter
        Equal...
        Equal or Before...
        Before...
        Equal or After...
        After...
        Between (inclusive)...
-----------------------
         Save Current Filter...
         Use Saved Filter...
         Manage Saved Filters... (delete and rename)
And maybe numeric values could have something similar

BR
BetterRed is offline   Reply With Quote
Old 08-24-2013, 09:08 PM   #13
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 25,308
Karma: 34628613
Join Date: Aug 2009
Location: The Central Coast of California
Device: K4NT(Fixed,New Bat.), Galaxy Tab A, Kobo Aura2
You can use (saved) searches on any datetype:

From the users guide:
Code:
The syntax for searching for dates is:

pubdate:>2000-1 Will find all books published after Jan, 2000
date:<=2000-1-3 Will find all books added to calibre before 3 Jan, 2000
pubdate:=2009 Will find all books published in 2009

If the date is ambiguous, the current locale is used for date comparison. For example, in an mm/dd/yyyy locale 2/1/2009 is interpreted as 1 Feb 2009. In a dd/mm/yyyy locale it is interpreted as 2 Jan 2009. Some special date strings are available. The string today translates to today’s date, whatever it is. The strings yesterday and thismonth (or the translated equivalent in the current language) also work. In addition, the string daysago (also translated) can be used to compare to a date some number of days ago. For example:

date:>10daysago
date:<=45daysago

To avoid potential problems with translated strings when using a non-English version of calibre, the strings _today, _yesterday, _thismonth, and _daysago are always available. They are not translated.
theducks is offline   Reply With Quote
Old 08-25-2013, 04:11 AM   #14
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 16,322
Karma: 19147306
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by theducks View Post
You can use (saved) searches on any datetype:

From the users guide:

...
@theducks - I knew there had to be a way

It would be helpful if something could be shown in Advanced Search dialogue to indicate the options that are available when a date or numeric column is the object of the search

Momentarily I tried to wrap my mind around how one could convert the date to a string using a template and then a regular expression on the result to express datewise comparisons - thankfully sanity prevailed

The manual page theducks quoted is here http://manual.calibre-ebook.com/gui....arch-interface

BR
Attached Thumbnails
Click image for larger version

Name:	Screenshot - 2013-08-25 , 17_49_40.jpg
Views:	179
Size:	49.0 KB
ID:	109974  
BetterRed is offline   Reply With Quote
Old 08-25-2013, 04:41 AM   #15
chaley
Grumpy old git
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: 9,203
Karma: 2901910
Join Date: Jan 2010
Location: UK
Device: Many android devices
Quote:
Originally Posted by BetterRed View Post
Momentarily I tried to wrap my mind around how one could convert the date to a string using a template and then a regular expression on the result to express datewise comparisons - thankfully sanity prevailed
FWIW: easy to do the conversion.

Create a composite column, not tags-like. Set the sort/search type to number. The template would be
Code:
{date:format_date(yyyy)}
where "date" is the lookup name for the date you are interested in. You now have a column showing just the year for the date.

If you check the "Show in tag browser" box in the column settings then you will see each year as a separate entry in the tag browser. Click on a year to see books for that year.

NB: in calibre v1.0.0, non-text sorting on composite columns is broken. Will be fixed in the next release, or now if you run from source. It won't matter for this example unless you have books with a date < the year 1000.
chaley is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Why no AND in Tag Browser Searching... ? BetterRed Calibre 7 04-22-2013 09:16 AM
Tag Browser Lady Fitzgerald Library Management 2 07-17-2012 11:54 PM
Help with tag browser partitioning Noughty Library Management 6 02-09-2012 09:42 AM
Tag browser searching Stampercam Calibre 2 06-25-2011 04:42 AM
Empty tag browser Rachel Calibre 18 07-26-2010 11:42 AM


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


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