On Sat, Oct 03, 2009 at 04:54:50AM -0700, yared berhanu wrote:
Greetings,
I'm Yared from Ethiopia, Hawassa University. I had a problem on MARC a couple of days and it was solved successfully. Now we were trying to install and us Koha 3.0.02 version on Ubuntu 8.04 LTS version for the University library information System. after a while when want to generate a guided report using the following sql statement it won't display the copynumber. the sql statement is as follow.
select b.title, itemcallnumber, barcode, copynumber, i.timestamp from biblio b, items i where b.biblionumber = i.biblionumber and homebranch ="TLIB" and i.timestamp > "2009-10-02 14:32:17"
But the copynumber does exist and is views with the catalogue view when we execute cgi-bin/koha/catalogue/MARCdetail.pl file.
MARC field has to be mapped to Koha table field if you want to display it in SQL report. Check your mapping: Administration -> Koha to MARC mapping Regards, Marijana