Re: [Koha] SQL help?

[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
||
*7* Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à
mesure.
 *q *Recycle always / Recicla siempre / Recyclez toujours
 P Print only if absolutely necessary / Imprime solo si es necesario /
Imprimez seulement si nécessaire


Le mar. 26 mai 2020 à 19:25, Kerrie Stevens  a
écrit :

> 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
> search box and get back a table showing those with outstanding loans:
> (borrower number, name, and number of current loans)
> Can cutting & pasting or searching on multiple borrower numbers be done in
> SQL reports?
> This is way beyond my basic level of SQL understanding, so any
> advice/assistance would be greatly appreciated.
>
> Thank you and have a great day wherever you may be!
>
>
> Kerrie Stevens  AALIA(CP), MAppSci(LibMgt), BBus(Info)
> Director of Library Services, Alphacrucis College
> Librarian - Melbourne Campus
> HDR Liaison Librarian
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] SQL help?

[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 search 
box and get back a table showing those with outstanding loans:
(borrower number, name, and number of current loans)
Can cutting & pasting or searching on multiple borrower numbers be done in SQL 
reports?
This is way beyond my basic level of SQL understanding, so any 
advice/assistance would be greatly appreciated.

Thank you and have a great day wherever you may be!


Kerrie Stevens  AALIA(CP), MAppSci(LibMgt), BBus(Info)
Director of Library Services, Alphacrucis College
Librarian - Melbourne Campus
HDR Liaison Librarian
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [EXTERNAL] Report help needed

[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, ExtractValue(metadata,'//leader') AS 
"Leader Field", SUBSTRING(ExtractValue(metadata,'//leader'),7,1) AS "Position05"
FROM biblio
LEFT JOIN biblio_metadata USING (biblionumber)
WHERE SUBSTRING(ExtractValue(metadata,'//leader'),7,1) = 'a'

If you change that final little 'a' to, e.g., 'e' you get all the cartographic 
resources.  The "7" somehow gets you position 6, and "6" would get you position 
5 in the Leader...somehow.

Cheerio!
h2

~~~

Ms. Heather Hernandez (she, her, hers)
Technical Services Librarian
San Francisco Maritime National Historical Park Research Center
2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA  94123-1284
415-561-7032, 
heather_hernan...@nps.gov
Library catalog: http://keys.bywatersolutions.com/
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Report help needed

[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 following
message: Unknown column 'marcxml' in 'field list'
Please check the log for further details.
Also, I don't understand how to indicate Leader position 06

 SELECT CONCAT('',biblionumber,'')

AS biblionumber

FROM biblioitems,

(SELECT biblioitemnumber, SUBSTR(marcxml,INSTR(marcxml, "")+8+6,1)

AS leader6 FROM biblioitems)

AS leaders

WHERE biblioitems.biblioitemnumber=leaders.biblioitemnumber AND
leaders.leader6 = 'a'

AND itemtype = <>

Any help would be appreciated

stay safe,

Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha