Hi Elaine,
The biblioitems.marcxml field has been moved to biblio_metadata.metadata.
Does this query work as you want:
SELECT CONCAT('',b.biblionumber,'')
AS biblionumber
FROM biblio b
LEFT JOIN biblioitems bi ON b.biblionumber= bi.biblionumber
LEFT JOIN biblio_metadata bm ON b.biblionumber=bm.b
Hello Kerrie,
I am not sure this is what you want, but if you create a SQL report
with this query you will see the patrons with outstanding loans:
SELECT b.borrowernumber, concat(b.surname, ' ', b.firstname), count(*)
FROM issues
LEFT JOIN borrowers b on b.borrowernumber=issues.borrowernumber
GRO
Hi Kerrie,
if you don't mind hardcoding the borrowernumbers this should do the trick.
SELECT
b.borrowernumber AS 'Borrowernumber',
CONCAT(b.firstname, ' ', b.surname) AS 'Name',
COUNT(i.issue_id) AS 'Outstanding loans'
FROM borrowers b
LEFT JOIN issues i ON b.borrowernumber = i.borrow
Can someone suggest report for getting accession number with a range from
and to
--
Assistant Librarian,
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Yes, I think I've got it now. Thanks for your help. The hard part was
figuring out where to find the itemtype in the bib record.
SELECT biblio.biblionumber,
SUBSTRING(ExtractValue(metadata,'//leader'),7,1) AS "Position06"
FROM biblio
LEFT JOIN biblio_metadata USING (biblionumber)
WHERE ExtractVal
Elaine,
Maybe this would be helpful for those codes -
https://www.loc.gov/marc/bibliographic/bdleader.html
And, to break it down for those that do not know and are interested, (at
the risk of condescending, which is not my intention, please, please, I
hope you do not take it that way)
in the exp
Not condescending at all, the things I don't know about reports would fill
a book.
Interesting report you have there by the way.
The purpose for mine is to double check the position 06 against the 942 $c
because there is a bug 19419 that seems to cause trouble with the 008 if
the Leader 06 is not s
Thank you. I'm unfamiliar with that particular bug and will check it out
for our records.
Best,
Michael
_
*Michael J. Sutherland*
University Libraries
Virginia Tech
sudrl...@vt.edu | 540.231.9669 <+15402319669>
On Wed, May 27, 2020 at 7:05 PM Elaine Bradt
Excerpts from Michael Sutherland's message of 2020-05-27 16:59:50 -0400:
> CASE SUBSTR(metadata,282,2)
I tried this myself, and it does seem to work. But I worry that
the 282 value might not be correct in the future, should the XML
format of the metadata change even slightly. In particular,
the
Hi Kerrie,
The workflow that we've developed utilizes patron lists. When the list of
prospective graduates is prepared by the registrar's office, I put them all
into a patron list. Yes, this involves looking up individual students by
name, but I only have to do this once. After they are in the lis
Hi, Michael--
That's fantastic!! Thank you so much for sharing it!
Best,
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
11 matches
Mail list logo
