Re: [Koha] Missing barcode number ascending order -SQL query

the SQL query Missing barcode in a range Developer: Josef Moravec Module: Catalog Purpose: If you want to fill the gaps in your barcodes row for items Status: Complet 1) SELECT (i1.barcode + 1) AS gap_starts_at, (SELECT MIN(i3.barcode) -1 FROM items i3 WHERE i3.barcode > i1.barcode) AS

Re: [Koha] Missing barcode number ascending order -SQL query

> Can anyone help me to get missing barcode number -SQL query. Can you please explain in more detail what you're trying to do? Which query in the SQL library did you try, and how did it fall short? -- Owen -- Web Developer Athens County Public Libraries (740) 737-6006 https://www.myacpl.org

[Koha] Missing barcode number ascending order -SQL query

Hi Can anyone help me to get missing barcode number -SQL query. I tried one -SQL query available on koha wiki I am not getting in proper order it shows only starting ending ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz