https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19495
Bug ID: 19495
Summary: Automatic report conversion needs to do global replace
on 'biblioitems' and 'marcxml'
Change sponsored?: ---
Product: Koha
Version: 17.05
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Reports
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
Bug 17898 provides a way of converting reports that use biblioitems.marcxml so
that they will use biblio_metadata.metadata instead.
This only works with reports that do not refer to other columns in the
biblioitems table. This is a known limitation. It means that we should be able
to do a substitution of every occurrence of biblioitems with biblio_metadata,
and every occurrence of marcxml with metadata.
Unfortunately, we're not doing a global replace, we're only replacing the first
occurrence. Here's the original:
SELECT
biblio.title,
biblio.biblionumber,
A.barcode,ExtractValue(biblioitems.marcxml,'//controlfield[@tag="001"]') AS
"field_001",
A.itemcallnumber,
A.itype
FROM
items A
JOIN biblio on (A.biblionumber = biblio.biblionumber)
JOIN biblioitems on (A.biblionumber = biblioitems.biblionumber)
WHERE
withdrawn = 1 AND A.biblionumber NOT in (
SELECT
biblionumber
FROM
items B
WHERE
B.itemnumber != A.itemnumber
)
And here's the converted:
SELECT
biblio.title,
biblio.biblionumber,
A.barcode,ExtractValue(biblio_metadata.metadata,'//controlfield[@tag="001"]')
AS "field_001",
A.itemcallnumber,
A.itype
FROM
items A
JOIN biblio on (A.biblionumber = biblio.biblionumber)
JOIN biblioitems on (A.biblionumber = biblioitems.biblionumber)
WHERE
withdrawn = 1 AND A.biblionumber NOT in (
SELECT
biblionumber
FROM
items B
WHERE
B.itemnumber != A.itemnumber
)
Note that there are three occurrences of 'biblioitems' in the first query, but
only the first has been substituted in the second.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
