Re: [Koha] INVENTORY SQL

2023-07-06 Thread muiru james
Hello Joel Thank you for your email. I need books that have been since that date and after (>=) but the date should be picked from a date picker. Then add all books on loan for that particular item type. So that the total at a particular date shall be all books after that datelastseen plus all bo

Re: [Koha] INVENTORY SQL

2023-07-06 Thread Coehoorn, Joel
Do you need to match the exact date last seen, books that have been seen since that date, or books that haven't been seen since before that date? Also, the part about combining books on loan is not clear. Can you explain that in more detail? *Joel Coehoorn* Director of Information Technology *Yor

[Koha] INVENTORY SQL

2023-07-06 Thread muiru james
Hello team, Im trying to create a sql query that will return a count of books that will have a datelastseen from a date picker and combine/add all books on loan for the particular itemtype. I have 2 different itemtypes and would like a count for each itemtype to include those with a datelastseen

Re: [Koha] Announcement: KohaCon24 to be held in Montréal, Canada

2023-07-06 Thread Eric Bégin
Thanks, Owen, and to all those who dared to accept Montreal as the next location. I'm pretty stoked about that. Special thanks to Caroline for preparing the proposal :-) Can't wait to see you ALL in Montreal!!! Meanwhile, see you in Finland. Eric Bégin Solutions inLibro inc. Le 7/6/23 à 11

[Koha] The Terrific Every-Other-Thursday Training Video | S3E22 | Current Session Checkout Slips

2023-07-06 Thread BRANNON, CHRISTOPHER
Quick! Check this out! Don't let this episode slip by! Print the most recent checkouts on your quick slips with these handy slip tips. Christopher and George show a couple ways to tackle this challenge using Template Toolkit. https://youtu.be/GbSb4sze2DU Christopher Brannon 2023 koha-US Presiden

[Koha] Announcement: KohaCon24 to be held in Montréal, Canada

2023-07-06 Thread Owen Leonard
Greetings, In the IRC General Meeting held today, the proposal for KohaCon24 by inLibro to host in Montréal was accepted unanimously by all present. The conference will be open to in-person and online participation. Their proposal can be seen here: https://wiki.koha-community.org/wiki/KohaCon24_P

[Koha] Koha-US System Administration Special Interest Group, 7/11/23

2023-07-06 Thread Andrew Fuerste-Henry
Good morning! The Koha-US System Administraiton Special Interest Group will meet Tuesday, July 11, 8 PT / 9 MT / 10 CT / 11 ET. We discuss system preferences and all the other fun nonsense that lives in the Administration module, along with SQL questions, bugs of note, and whatever other mad s

Re: [Koha] record won't delete

2023-07-06 Thread Jonathan Druart
Hi Lauren, did you have a look at the wiki page? https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix Le mer. 5 juil. 2023 à 20:50, Lauren Denny a écrit : > > Hi Jonathan, > > Thanks for the SQL. We ran the report and got 6 biblionumbers including the > one we tried to delete. I'm not

Re: [Koha] regex to put space between the classification number and author letters

2023-07-06 Thread David Liddle
Lauren, I don't know if you got a direct personal answer to this, but having tried my hand at the question at https://regex101.com/, the following regular expression matches your samples: (.?[0-9]{3})([A-Z]{2}) and the following inserts a space in the correct position: $1 $2 On Thu, Jun 29, 20