I think you should use the column 'cn_sort' of items.
It contains the item callnumber stored in a special form depending on
classification source (see /cgi-bin/koha/admin/classsources.pl).
Regards,
Le 19/07/2013 04:51, Nicholas van Oudtshoorn a écrit :
Greetings all!
Got a bit of a question here. As part of our academic (re)accreditation
process, we need to provide a list of books aquired in a specific
subject area over the past year. Fantastic - the Catalogue Report should
do all that. (Well, it should do it when the patches in bug report 10608
are applied!)
My problem: how to restrict the report according to the dewey number of
the items. (This is, I think, the easiest way for us to show which books
relevant to a specific subject area). However, looking at the code, it
appears in catalogue_stats.pl that $has_dewey is disabled (in fact, the
comment says it doesn't work - not sure why it and its remnants remain
in both the perl and the templates???)
So, unable to filter on dewey number, I've taken to filtering on the
koha full call number. The problem is that I want to filter on the dewey
part of the call number - not the full string. And this causes problems.
Let me demonstrate. Using the current code path, if I'm searching for
items between 227.0 and 227.15, I get 299 records (see APPENDIX A).
Changing the code to cast the call number to a float as below (which
gives me just the dewey localtion)
if (@$filters[4]){
@$filters[4]=~ s/\*/%/g ;
$strcalc .= " AND items.itemcallnumber >= (0+" .
$dbh->quote(@$filters[4]) .")";
}
if (@$filters[5]){
@$filters[5]=~ s/\*/%/g;
$strcalc .= " AND items.itemcallnumber <= (0+" .
$dbh->quote(@$filters[5]) .")";
}
now gives me 308 records (see APPENDIX B) - including ones like 227 BRU
where the decimal component (227.0) is implied.
My question (at last!): is changing the code as above the right way to
go about fixing this problem? (I realise that ideally one would want to
make it an option in the report....).
This same issue applies to other report modules - such as the
circulation stats....
Any suggestions? How do other libraries deal with this?
God bless,
Nicholas van Oudtshoorn
IT - Perth Bible College
http://library.pbc.wa.edu.au/
APPENDIX A: THE ORIGINAL CODE PATH'S OUTPUT
----------------------------------------------------------------------------------------
items.itemcallnumber / items.homebranch TOTAL
227.02 BAR 1
227.02 BIR 1
227.02 DAV 1
227.02 DOD 1
227.02 DUN 1
227.02 ELL 1
227.02 ENG 1
227.02 GOM 1
227.02 GOO 1
227.02 GOR 1
227.02 GRI 1
227.02 KRU 1
227.02 LOA 1
227.02 MCR 1
227.02 MEY 1
227.02 NEY 1
227.02 OBR 1
227.02 RAM 1
227.02 REY 2
227.02 RID 1
227.02 ROB 1
227.02 SCH 3
227.02 SEI 1
227.02 SOB 1
227.02 STE 1
227.02 STR 2
227.02 TOI 2
227.02 WIL 1
227.02 WRI 3
227.02 YOU 1
227.02 ZIE 1
227.03 HAW 1
227.05 GAS 2
227.06 CAM 1
227.06 ELL 1
227.06 FOW 1
227.06 GRO 1
227.06 HAF 1
227.06 HAN 2
227.06 KEC 1
227.06 KRE 1
227.06 MAR 1
227.06 REA 1
227.06 SCR 1
227.06 STE 1
227.06 THI 1
227.06 WHI 1
227.066 BAN 2
227.066 DOT 1
227.066 HAN 1
227.066 REI 1
227.07 WES 1
227.08 WIL 1
227.08251 MUR 1
227.09 ARM 1
227.09 CON 2
227.09 GRO 1
227.09 HOW 1
227.09 MEI 1
227.09 OAK 1
227.09 PIN 1
227.09 RIC 1
227.09 SCH 1
227.091 RAM 1
227.092 DUN 2
227.092 OBR 1
227.092 WHI 1
227.1 ACH 1
227.1 BAR 10
227.1 BAR v.1 1
227.1 BAR v.2 1
227.1 BAR v.3 1
227.1 BAR v.4 1
227.1 BES 3
227.1 BLA 3
227.1 BOI 1
227.1 BOI v.3c.1 1
227.1 BOW 1
227.1 BRA 1
227.1 BRA v.6c.2 1
227.1 BRI 1
227.1 BRU 3
227.1 BUR 1
227.1 BYR 1
227.1 CHA 1
227.1 COA 1
227.1 COF 1
227.1 COS 1
227.1 CRA 3
227.1 DAV 1
227.1 DAW 1
227.1 DEH 1
227.1 DEW 1
227.1 DOD 4
227.1 DON 1
227.1 DUN v.1 1
227.1 DUN v.2 1
227.1 DYK 1
227.1 EDW 2
227.1 ELL 2
227.1 EPP 2
227.1 EPP V.1 1
227.1 EPP V.2 1
227.1 FIT 1
227.1 FOR 1
227.1 GOD v.1c.1 1
227.1 GOD v.2c.1 1
227.1 GRA 1
227.1 GRI 1
227.1 HAL 2
227.1 HAR 2
227.1 HEN 2
227.1 HOD 2
227.1 HOY 1
227.1 HUN 4
227.1 IRO 2
227.1 JOH 2
227.1 JOH v.1 1
227.1 JOH v.2 1
227.1 KAS 2
227.1 KEE 1
227.1 KEL 1
227.1 KIR 1
227.1 KRO 1
227.1 KRU 1
227.1 KUN 1
227.1 LEN 1
227.1 LLO v.11 1
227.1 LLO v.12 1
227.1 LLO v.1c.1 1
227.1 LLO v.2c.1 1
227.1 LLO v.3 1
227.1 LLO v.3c.2 1
227.1 LLO v.4 1
227.1 LLO v.4c.2 1
227.1 LLO v.5c.1 1
227.1 LLO v.5c.2 1
227.1 LLO v.6 1
227.1 LLO v.6c.2 1
227.1 LLO v.7 1
227.1 LLO v.7c.2 1
227.1 LLO v.8 1
227.1 LLO v.9c.1 1
227.1 LOA 1
227.1 LUT 2
227.1 MAC 1
227.1 MAC v.1c.1 1
227.1 MAC v.2c.1 1
227.1 MAL 1
227.1 MAT 1
227.1 MCC 2
227.1 MCD 1
227.1 MEE 1
227.1 MIT 2
227.1 MOO 7
227.1 MOR 3
227.1 MOU 6
227.1 MUR 2
227.1 MUR v.1c.2 1
227.1 NAS 3
227.1 NEW 2
227.1 NYG 2
227.1 NYS 1
227.1 OLS 1
227.1 OSB 1
227.1 PAI 1
227.1 PAL 1
227.1 PAT 1
227.1 PBC v.10 1
227.1 PBC v.1c.1 1
227.1 PBC v.2c.1 1
227.1 PBC v.3c.1 1
227.1 PBC v.4c.1 1
227.1 PBC v.5c.1 1
227.1 PBC v.6c.1 1
227.1 PBC v.7c.1 1
227.1 PBC v.8c.1 1
227.1 PBC v.9c.1 1
227.1 PET 1
227.1 PHI 1
227.1 PHI v.1 1
227.1 PHI v.2 1
227.1 RAT 1
227.1 RHY 1
227.1 RID 3
227.1 SAN 3
227.1 SCH 5
227.1 SCO 1
227.1 SCR 1
227.1 SEC 1
227.1 SHU 1
227.1 SPR 1
227.1 STE 2
227.1 STH 1
227.1 STO 3
227.1 STO v.1c.1 1
227.1 STO v.1c.2 1
227.1 STU 1
227.1 THO v.1c.1 1
227.1 THO v.2c.1 1
227.1 THO v.3c.1 1
227.1 THR 1
227.1 TUC 1
227.1 VIN 1
227.1 WIE 2
227.1 WIL 1
227.1 WUE 3
227.1 ZIE 1
227.104 IRO 1
227.105 SWA 1
227.106 DEI 1
227.106 GAT 1
227.106 GRE 1
227.106 MOU 1
227.106 SAB 1
227.106 SOD 1
227.107 PAU 1
227.108 WAL 1
227.12 GAM 1
TOTAL 299
APPENDIX B: THE MODIFIED CODE PATH'S OUTPUT:
---------------------------------------------------------------------------------
items.itemcallnumber / items.homebranch TOTAL
227 BRU 1
227 FAL 1
227 HEB 1
227 LAK 1
227 MAC 1
227 RIC 1
227 SHE 1
227 STE 1
227 WAY 1
227.02 BAR 1
227.02 BIR 1
227.02 DAV 1
227.02 DOD 1
227.02 DUN 1
227.02 ELL 1
227.02 ENG 1
227.02 GOM 1
227.02 GOO 1
227.02 GOR 1
227.02 GRI 1
227.02 KRU 1
227.02 LOA 1
227.02 MCR 1
227.02 MEY 1
227.02 NEY 1
227.02 OBR 1
227.02 RAM 1
227.02 REY 2
227.02 RID 1
227.02 ROB 1
227.02 SCH 3
227.02 SEI 1
227.02 SOB 1
227.02 STE 1
227.02 STR 2
227.02 TOI 2
227.02 WIL 1
227.02 WRI 3
227.02 YOU 1
227.02 ZIE 1
227.03 HAW 1
227.05 GAS 2
227.06 CAM 1
227.06 ELL 1
227.06 FOW 1
227.06 GRO 1
227.06 HAF 1
227.06 HAN 2
227.06 KEC 1
227.06 KRE 1
227.06 MAR 1
227.06 REA 1
227.06 SCR 1
227.06 STE 1
227.06 THI 1
227.06 WHI 1
227.066 BAN 2
227.066 DOT 1
227.066 HAN 1
227.066 REI 1
227.07 WES 1
227.08 WIL 1
227.08251 MUR 1
227.09 ARM 1
227.09 CON 2
227.09 GRO 1
227.09 HOW 1
227.09 MEI 1
227.09 OAK 1
227.09 PIN 1
227.09 RIC 1
227.09 SCH 1
227.091 RAM 1
227.092 DUN 2
227.092 OBR 1
227.092 WHI 1
227.1 ACH 1
227.1 BAR 10
227.1 BAR v.1 1
227.1 BAR v.2 1
227.1 BAR v.3 1
227.1 BAR v.4 1
227.1 BES 3
227.1 BLA 3
227.1 BOI 1
227.1 BOI v.3c.1 1
227.1 BOW 1
227.1 BRA 1
227.1 BRA v.6c.2 1
227.1 BRI 1
227.1 BRU 3
227.1 BUR 1
227.1 BYR 1
227.1 CHA 1
227.1 COA 1
227.1 COF 1
227.1 COS 1
227.1 CRA 3
227.1 DAV 1
227.1 DAW 1
227.1 DEH 1
227.1 DEW 1
227.1 DOD 4
227.1 DON 1
227.1 DUN v.1 1
227.1 DUN v.2 1
227.1 DYK 1
227.1 EDW 2
227.1 ELL 2
227.1 EPP 2
227.1 EPP V.1 1
227.1 EPP V.2 1
227.1 FIT 1
227.1 FOR 1
227.1 GOD v.1c.1 1
227.1 GOD v.2c.1 1
227.1 GRA 1
227.1 GRI 1
227.1 HAL 2
227.1 HAR 2
227.1 HEN 2
227.1 HOD 2
227.1 HOY 1
227.1 HUN 4
227.1 IRO 2
227.1 JOH 2
227.1 JOH v.1 1
227.1 JOH v.2 1
227.1 KAS 2
227.1 KEE 1
227.1 KEL 1
227.1 KIR 1
227.1 KRO 1
227.1 KRU 1
227.1 KUN 1
227.1 LEN 1
227.1 LLO v.11 1
227.1 LLO v.12 1
227.1 LLO v.1c.1 1
227.1 LLO v.2c.1 1
227.1 LLO v.3 1
227.1 LLO v.3c.2 1
227.1 LLO v.4 1
227.1 LLO v.4c.2 1
227.1 LLO v.5c.1 1
227.1 LLO v.5c.2 1
227.1 LLO v.6 1
227.1 LLO v.6c.2 1
227.1 LLO v.7 1
227.1 LLO v.7c.2 1
227.1 LLO v.8 1
227.1 LLO v.9c.1 1
227.1 LOA 1
227.1 LUT 2
227.1 MAC 1
227.1 MAC v.1c.1 1
227.1 MAC v.2c.1 1
227.1 MAL 1
227.1 MAT 1
227.1 MCC 2
227.1 MCD 1
227.1 MEE 1
227.1 MIT 2
227.1 MOO 7
227.1 MOR 3
227.1 MOU 6
227.1 MUR 2
227.1 MUR v.1c.2 1
227.1 NAS 3
227.1 NEW 2
227.1 NYG 2
227.1 NYS 1
227.1 OLS 1
227.1 OSB 1
227.1 PAI 1
227.1 PAL 1
227.1 PAT 1
227.1 PBC v.10 1
227.1 PBC v.1c.1 1
227.1 PBC v.2c.1 1
227.1 PBC v.3c.1 1
227.1 PBC v.4c.1 1
227.1 PBC v.5c.1 1
227.1 PBC v.6c.1 1
227.1 PBC v.7c.1 1
227.1 PBC v.8c.1 1
227.1 PBC v.9c.1 1
227.1 PET 1
227.1 PHI 1
227.1 PHI v.1 1
227.1 PHI v.2 1
227.1 RAT 1
227.1 RHY 1
227.1 RID 3
227.1 SAN 3
227.1 SCH 5
227.1 SCO 1
227.1 SCR 1
227.1 SEC 1
227.1 SHU 1
227.1 SPR 1
227.1 STE 2
227.1 STH 1
227.1 STO 3
227.1 STO v.1c.1 1
227.1 STO v.1c.2 1
227.1 STU 1
227.1 THO v.1c.1 1
227.1 THO v.2c.1 1
227.1 THO v.3c.1 1
227.1 THR 1
227.1 TUC 1
227.1 VIN 1
227.1 WIE 2
227.1 WIL 1
227.1 WUE 3
227.1 ZIE 1
227.104 IRO 1
227.105 SWA 1
227.106 DEI 1
227.106 GAT 1
227.106 GRE 1
227.106 MOU 1
227.106 SAB 1
227.106 SOD 1
227.107 PAU 1
227.108 WAL 1
227.12 GAM 1
TOTAL 308
_______________________________________________
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
Biblibre - Pôle support
fridolyn.som...@biblibre.com
_______________________________________________
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/
