[Koha-devel] Numerically sorting a new Zebra Index

[Senthil Anand]

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...