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

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 11-21-2012, 11:26 AM   #1
DarkKniyt
Junior Member
DarkKniyt began at the beginning.
 
Posts: 1
Karma: 10
Join Date: Nov 2012
Device: Nook Tablet
Calibre Server Sort Issue

I have the Calibre-Server running on a home server and access it via a web browser on another pc.

I have a user added Column called "Chronology" that I wish to sort on when viewing from a web browser.

Right now the field has the following type of data in it:
'R1' thru 'R186'. (Indexed Series field type).

I can select "Chronology" from the home page and pull up the data but it is sorted starting from 'R186' with the last entry being 'R1'.

Is there a way to sort this in ascending-order?

Thanks in advance!
DarkKniyt is offline   Reply With Quote
Old 11-21-2012, 11:41 AM   #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: 26,154
Karma: 5381911
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
IIRC in the server interface you can change the field you sort on but not the order (i.e. not ascending vs. descending).
kovidgoyal is offline   Reply With Quote
Old 11-21-2012, 11:51 AM   #3
theducks
Grand Sorcerer
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: 14,902
Karma: 5880479
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
That field sort will not work for you because it will 'Alpha sort'
to sort you need to pad the numbers with Leading 0's so the digits all have the same number of places

R001

otherwise you will get :
R1
R10
R100
R2
R20
R3
theducks is offline   Reply With Quote
Reply

Tags
index, server, sort

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Minor issue with Aldiko reader and calibre-server apuder Devices 0 08-11-2012 09:18 PM
Calibre-server port not open issue on Fedora server stueyboy Devices 0 08-17-2011 04:57 PM
Calibre Server - Sort Problem gabglus Calibre 7 03-18-2011 07:14 PM
Issue with Calibre Server - Windows jawadams Calibre 13 01-13-2011 06:51 AM
PRS-505 author sort issue Worldwalker Calibre 6 03-17-2010 03:33 AM


All times are GMT -4. The time now is 10:46 AM.


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