Re: [Koha] SQL help?

2020-05-26 Thread Alvaro Cornejo
Hi Mysql does not have the ability to read info from any other place than its own tables. You can, however write an script in any language you know to loop through your borrowers file and check if they owe something. This shall be done at server level, not koha. Regards, Alvaro

[Koha] SQL help?

2020-05-26 Thread Kerrie Stevens
Every year, we need to confirm graduating students have no outstanding loans so they can graduate. And every year I think I must ask for some help in doing it more efficiently than searching borrower numbers one by one... I'd like to be able to copy & paste a number of borrower numbers into

Re: [Koha] [EXTERNAL] Report help needed

2020-05-26 Thread Hernandez, Heather H
Hi, Elaine! I am the newbiest of SQL report newbies, but I tend to "speak MARC21," and found a different report on the Koha Wiki that I was able to tweak and it seems to work in our catalog to retrieve all bibs with a Leader position 06 value of "a:" SELECT biblionumber, title, author,

[Koha] Report help needed

2020-05-26 Thread Elaine Bradtke
What I'd like it to do - give a list of biblio numbers for records with a particular itemtype, and the information found in the Leader *06 - Type of record *field. I found the following in the reports library as something that could be modified to fit my needs. But it doesn't work I get the