Thank you Irma, the information was helpful indeed
Chrs
Decka
From: Irma Birchall [mailto:i...@calyx.net.au]
Sent: Wednesday, July 20, 2016 1:48 PM
To: Decka David
Cc: Koha-List
Subject: Re: [Koha] Shelf List Report help
Hi David,
What about this one:
SELECT
Hi David,
What about this one:
SELECT
items.itemcallnumber,biblio.title,biblio.author,items.barcode,items.price,items.replacementprice
FROM items
LEFT JOIN biblioitems ON
(items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON
Dear Koha Community,
Please can someone help to provide insight into creating shelf list report
that includes the following;
1. Call Number
2. Title
3. Author
4. Barcode and
5. Cost
This sort of information and report can help our library into doing simple
Hi
We have this report that looks for 'unauthorized' 650s in a time range.
SELECT biblionumber, itemtype, ExtractValue(marcxml,
'//datafield[@tag="650"]/subfield[@code="a"]') AS heading FROM biblioitems
WHERE length(ExtractValue(marcxml,
'//datafield[@tag="650"]/subfield[@code="a"]')) != 0 AND
Hi all,
I don't understand why everybody is saying "good luck" and
"congratulations". Are you all so happy to see Nicole leaving ?
I'm so sad that I wish Nicole an epic fail. May an asteroid fall on your
moving truck, may you have a massive allergy to Ralleigh NC trees
pollen, may you face an
Dear all,
Does anyone monitor new authority headings (all types) created? If so, how
do you identify new headings created in a given time period? Custom
reports??
At this moment, there is no easy way to identify those new headings. Going
through the entire list of authority headings is very
6 matches
Mail list logo