[Koha-devel] Numerically sorting a new Zebra Index

[Fridolyn SOMERS]

Your welcome,

The whole Zebra search syntax seems completely alien to me
>

It was the same for me.
But with the only doc online (www.indexdata.com), I descovered a powerfull
search engine.

Good luke,

Regards,

On Sat, Dec 18, 2010 at 6:41 PM, Senthil Anand <ssenthilanand at gmail.com>wrote:

> Hello,
>
> I  am basically sorting pure numbers from a varchar field.
>
> After changing the record.abs to
> melm 952$z      canumber,canumber:n,canumber:s,item
>
> and using the query
> canumber,st-numeric>=<textbox value>
> and
> canumber,st-numeric<=<textbox value>
>
> with values 3 and 100 I get 11 items.
>
> mysql> select itemnotes from items where (itemnotes + 0) >= 3 and
> (itemnotes + 0) <= 100;
> ...
> 11 rows in set (1.16 sec)
>
> The corresponding barcodes are also identical in both cases.
> So it seems to work on my small test install in my netbook.
>
> Will check it in a larger test system with more varied canumber values
> in a few days and report back then.
>
> The whole Zebra search syntax seems completely alien to me after being
> used to SQL.
>
> Thanks for the tips.
>
> Regards,
> Senthil
>
>
> 2010/12/17 Fridolyn SOMERS <fridolyn.somers at gmail.com>:
> > You are right,
> >
> > I missed the @att type 4.
> > Then, it should also be set on query.
> >
> > I found another error : le and ge souldn't come with "=" : use ">=" ans
> > "<=".
> >
> > It gives :
> >
> > "(canumber,st-numeric>=1000 and canumber,st-numeric<=2000) or
> > sort1,canumber,st-numeric=0".
> >
> > PS :
> > The zero in sort1(...)=0 means that this sort in the first (in case there
> is
> > a second sort, sort=1, etc).
> >
> > If it doesn't work, send us the PQF(... @att ...) query from Zebra logs.
> >
> > Regards,
> >
> > On Fri, Dec 17, 2010 at 4:48 PM, LAURENT Henri-Damien
> > <henridamien.laurent at gmail.com> wrote:
> >>
> >> 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...
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/
>



-- 
Fridolyn SOMERS
ICT engineer
PROGILONE - Lyon - France
fridolyn.somers at gmail.com
-------------- section suivante --------------
Une pi?ce jointe HTML a ?t? nettoy?e...
URL: </pipermail/koha-devel/attachments/20101220/d3dc4e6e/attachment.htm>