[Koha-devel] Numerically sorting a new Zebra Index

[LAURENT Henri-Damien]

Le 17/12/2010 14:40, Fridolyn SOMERS a écrit :
> Hie,
> 
> Have a look at @att 7 of Zebra :
> http://www.indexdata.com/zebra/doc/querymodel-zebra.html#querymodel-zebra-attr-sorting
> 
> It introduces sorting into query.
> 
> In ccl.properties you find ascending and descending sort :
> /sort1 7=1
> sort2 7=2/
> 
> So your ccl query looks like :
> /"(canumber,ge=1000 and "canumber,le=2000) or sort1,canumber=0"/
> 
> *_PS : _*
> You must add the sort structure (:s) into "record.abs" :
> 
> melm 952$z    canumber, canumber:n, canumber:s, item
> 
> Regards,

Fridolyn, what you said is helpfull but not really fixes the problem...
It appears that it lies in @attr 4=109 that should be used and not @attr
4=1 or @attr 4=6...
That is to say Senthil has to tell on what TYPE of data he is trying to
sort.
Sorting on number is not the same as sorting alphabetical things.
so in pqf it would be
	@or your query  @attr 1=canumber @attr 7=1 @attr 4=109 1
in ccl
	yourquery or canumber,sort1,st-numeric=1
or edit the code so that it sends the correct queries.
Hopes that helps...

-- 
Henri-Damien LAURENT