Is there a way to write an SQL report where you can input a number of item barcodes (as you do when using batch modify or delete) that results in a table showing title, author, call number etc...? Thanks for any help you may provide! Kerrie Stevens AALIA(CP), MAppSc(Lib&InfoMgt)(CSU), BBus(InfoMgt)(RMIT) College Librarian First Aid Officer College Archivist Copyright Compliance Officer Journal Manager – Journal of Contemporary Ministry Harvest Bible College OFFICE: +61 3 8799 1111 DIRECT LINE: +61 3 8799 1155 EMAIL: kstevens@harvest.edu.au STREET ADDRESS: 1 Keith Campbell Court, Scoresby VIC 3179 AUSTRALIA POSTAL ADDRESS: PO BOX 9183, Scoresby VIC 3179 AUSTRALIA WORKING HOURS: Mon - Thurs 8.30am – 4.30pm, Fri 8.30am – 3pm harvest.edu.au CRICOS CODE: 01035C (VIC) Harvest Bible College Ltd. [RTO: 0067] DISCLAIMER: The information contained in this e-mail is confidential and may also be privileged. Opinions expressed are those of the sender and not necessarily the opinions of Harvest Bible College. If you are not the addressee, any use of this communication is strictly prohibited. If you have received this message in error, please contact info@harvest.edu.au While Harvest Bible College is using the latest antiviral tools, we do not except responsibility for problems caused by virus or other destructive mechanisms which may be attached to electronic communication. Please scan this email and other attachment for viruses.
Hi Kerrie, I can only find single barcode search that you could find it in SQL Library..here.. https://wiki.koha-community.org/wiki/SQL_Reports_Library#Barcode_Search_Repo... And somebody could help you in enhancing this sql for multiple barcode search. Regards Satish Librarian Govt. Engineering College, Hassan
And Barcodes can be searched with wild cards '%' or '_' eg: 45% results in 45, 451,452,453..459, 4500 this would help you to some extent.
Hello Kerrie, This should work: Select title, author, i.itemcallnumber from biblio b Left join biblioitems bi on b.biblionumber=bi.biblionumber Left join items i on bi.biblionumber=i.biblionumber where i.barcode IN ("BARCODE1", "BARCODE2", "BARCODE3"); GL, Pedro Amorim On 11 December 2017 at 04:39, SATISH <lis4satish@gmail.com> wrote:
And Barcodes can be searched with wild cards '%' or '_'
eg: 45% results in 45, 451,452,453..459, 4500 this would help you to some extent. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Excerpts from Pedro Amorim's message of 2017-12-11 14:18:08 -0100:
This should work:
Select title, author, i.itemcallnumber from biblio b Left join biblioitems bi on b.biblionumber=bi.biblionumber Left join items i on bi.biblionumber=i.biblionumber where i.barcode IN ("BARCODE1", "BARCODE2", "BARCODE3");
This can also be made into an SQL report using multiple entry fields for the barcodes. It's a bit of a kludge but seems to work because the blank fields are treated either as '' or NULL in the generated SQL. Select title, author, i.itemcallnumber from biblio b Left join biblioitems bi on b.biblionumber=bi.biblionumber Left join items i on bi.biblionumber=i.biblionumber where i.barcode = <<Barcode #1>> or i.barcode = <<Barcode #2>> or i.barcode = <<Barcode #3>> or i.barcode = <<Barcode #4>> or i.barcode = <<Barcode #5>> or i.barcode = <<Barcode #6>>
what version of KOHA ? On 11/12/2017 02:18 πμ, Kerrie Stevens wrote:
Is there a way to write an SQL report where you can input a number of item barcodes (as you do when using batch modify or delete) that results in a table showing title, author, call number etc...?
Thanks for any help you may provide!
Kerrie Stevens AALIA(CP), MAppSc(Lib&InfoMgt)(CSU), BBus(InfoMgt)(RMIT)
College Librarian First Aid Officer College Archivist Copyright Compliance Officer Journal Manager – Journal of Contemporary Ministry
Harvest Bible College
OFFICE: +61 3 8799 1111 DIRECT LINE: +61 3 8799 1155 EMAIL: kstevens@harvest.edu.au STREET ADDRESS: 1 Keith Campbell Court, Scoresby VIC 3179 AUSTRALIA POSTAL ADDRESS: PO BOX 9183, Scoresby VIC 3179 AUSTRALIA WORKING HOURS: Mon - Thurs 8.30am – 4.30pm, Fri 8.30am – 3pm
harvest.edu.au CRICOS CODE: 01035C (VIC) Harvest Bible College Ltd. [RTO: 0067]
DISCLAIMER: The information contained in this e-mail is confidential and may also be privileged. Opinions expressed are those of the sender and not necessarily the opinions of Harvest Bible College. If you are not the addressee, any use of this communication is strictly prohibited. If you have received this message in error, please contact info@harvest.edu.au While Harvest Bible College is using the latest antiviral tools, we do not except responsibility for problems caused by virus or other destructive mechanisms which may be attached to electronic communication. Please scan this email and other attachment for viruses.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
This is a quite unfinished stub, but it aims to allow for letting you input a list into a report: https://github.com/bywatersolutions/koha-reports-plus On Mon, Dec 11, 2017 at 8:20 PM DHD.KOHA <dhd.koha@gmail.com> wrote:
what version of KOHA ?
Is there a way to write an SQL report where you can input a number of item barcodes (as you do when using batch modify or delete) that results in a table showing title, author, call number etc...?
Thanks for any help you may provide!
Kerrie Stevens AALIA(CP), MAppSc(Lib&InfoMgt)(CSU), BBus(InfoMgt)(RMIT)
College Librarian First Aid Officer College Archivist Copyright Compliance Officer Journal Manager – Journal of Contemporary Ministry
Harvest Bible College
OFFICE: +61 3 8799 1111 <+61%203%208799%201111> DIRECT LINE: +61 3 8799 1155 <+61%203%208799%201155> EMAIL: kstevens@harvest.edu.au STREET ADDRESS: 1 Keith Campbell Court, Scoresby VIC 3179 AUSTRALIA POSTAL ADDRESS: PO BOX 9183, Scoresby VIC 3179 AUSTRALIA WORKING HOURS: Mon - Thurs 8.30am – 4.30pm, Fri 8.30am – 3pm
harvest.edu.au CRICOS CODE: 01035C (VIC) Harvest Bible College Ltd. [RTO: 0067]
DISCLAIMER: The information contained in this e-mail is confidential and may also be privileged. Opinions expressed are those of the sender and not necessarily the opinions of Harvest Bible College. If you are not the addressee, any use of this communication is strictly prohibited. If you have received this message in error, please contact info@harvest.edu.au While Harvest Bible College is using the latest antiviral tools, we do not except responsibility for problems caused by virus or other destructive mechanisms which may be attached to electronic communication. Please scan
On 11/12/2017 02:18 πμ, Kerrie Stevens wrote: this email and other attachment for viruses.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
This is awesome, Nick. I'm bookmarking this for future reference, thanks a lot! On 13 December 2017 at 15:27, Nick Clemens <nick@bywatersolutions.com> wrote:
This is a quite unfinished stub, but it aims to allow for letting you input a list into a report: https://github.com/bywatersolutions/koha-reports-plus
On Mon, Dec 11, 2017 at 8:20 PM DHD.KOHA <dhd.koha@gmail.com> wrote:
what version of KOHA ?
Is there a way to write an SQL report where you can input a number of item barcodes (as you do when using batch modify or delete) that results in a table showing title, author, call number etc...?
Thanks for any help you may provide!
Kerrie Stevens AALIA(CP), MAppSc(Lib&InfoMgt)(CSU), BBus(InfoMgt)(RMIT)
College Librarian First Aid Officer College Archivist Copyright Compliance Officer Journal Manager – Journal of Contemporary Ministry
Harvest Bible College
OFFICE: +61 3 8799 1111 <+61%203%208799%201111> DIRECT LINE: +61 3 8799 1155 <+61%203%208799%201155> EMAIL: kstevens@harvest.edu.au STREET ADDRESS: 1 Keith Campbell Court, Scoresby VIC 3179 AUSTRALIA POSTAL ADDRESS: PO BOX 9183, Scoresby VIC 3179 AUSTRALIA WORKING HOURS: Mon - Thurs 8.30am – 4.30pm, Fri 8.30am – 3pm
harvest.edu.au CRICOS CODE: 01035C (VIC) Harvest Bible College Ltd. [RTO: 0067]
DISCLAIMER: The information contained in this e-mail is confidential and may also be privileged. Opinions expressed are those of the sender and not necessarily the opinions of Harvest Bible College. If you are not the addressee, any use of this communication is strictly prohibited. If you have received this message in error, please contact info@harvest.edu.au While Harvest Bible College is using the latest antiviral tools, we do not except responsibility for problems caused by virus or other destructive mechanisms which may be attached to electronic communication. Please scan
On 11/12/2017 02:18 πμ, Kerrie Stevens wrote: this email and other attachment for viruses.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (6)
-
DHD.KOHA -
Kerrie Stevens -
Mark Alexander -
Nick Clemens -
Pedro Amorim -
SATISH