Hie, Have a look at @att 7 of Zebra : http://www.indexdata.com/zebra/doc/querymodel-zebra.html#querymodel-zebra-at... 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, On Thu, Dec 16, 2010 at 3:21 PM, Senthil Anand <ssenthilanand@gmail.com>wrote:
Hello,
Running Koha 3.06 on Centos 5.5.
I want to add a new item attribute, canumber to the Zebra Index. It should be visible on the staff client. All values are numbers ranging from 1 to around 15000000.
I have done the following steps:
1. In bib1.att
att 8032 canumber
2. In the marc21 record.abs
melm 952$z canumber, canumber:n, item
3. In ccl.properties
canumber 1=8032
Zebra has been reindexed.
I want to use the canumber in place of acq-date in the Bulk label barcode generation.
In label-item-search.pl under intranet/cgi-bin/labels . I am performing a search using the following limits :
"canumber,ge="<textbox data> and
"canumber,le="<textbox data>.
The search actually works and returns results but the results seem to be sorted as text. ie searching beween 1000 and 1010 returns items with canumber 1000000 etc. As a test I changed the attribute of itemnotes in items table from varchar to int(11) in a test machine and reran the index. Still not getting proper numeric sorting.
The Zebra docs mention that lexicographic sorting is default and numeric sorting has to be enabled. As I understood it is defined in the record.abs. How can I change the mappings in record.abs to get numerically sorted results ? Is the query I am using in label-item-search.pl correct ?
Regards, Senthil _______________________________________________ Koha-devel mailing list Koha-devel@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@gmail.com