Loading ...
Sorry, an error occurred while loading the content.

Re: [plagpk] koha report

Expand Messages
  • Rehana Kousar
    Dear Monisa Aslam, Please find the attached documents, I hope it will be helpful for you. Regards, REHANA KOUSAR  Incharge Librarian Central Park Medical
    Message 1 of 2 , Jun 4, 2013
    • 1 Attachment
    • 615 KB

    Dear Monisa Aslam,

    Please find the attached documents, I hope it will be helpful for you.

    Regards,

    REHANA KOUSAR
     Incharge Librarian
    Central Park Medical College
    31 km. Ferozepur Road
    Lahore
     
     


    From: Monisa Aslam <monisaaslam@...>
    To: "plagpk@yahoogroups.com" <plagpk@yahoogroups.com>
    Sent: Friday, May 31, 2013 10:46 PM
    Subject: [plagpk] koha report

     

    can any one guide me about a report in koha. a report is about All the bibs records with there control field 001

    i want a report for accession register sorted by control field 001, can anyone help me.

    pls note that all my records dont have item and also some of the record have 001 also empty but i need to have a complete list. pls help

    what i made is 

    SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\">',biblio.biblionumber,'</a>') AS biblionumbers, 
           items.barcode, items.dateaccessioned, items.itemcallnumber, biblioitems.isbn, biblio.author, biblio.title, biblioitems.pages, 
           biblioitems.publishercode, biblioitems.place, biblio.copyrightdate, ExtractValue(marcxml,'//controlfield[@tag="001"]') 
    FROM  biblioitems
    ORDER BY LPAD(biblio.title,40,' ') ASC





Your message has been successfully submitted and would be delivered to recipients shortly.