Or like this, which might (or might not!) be more efficient since it
only resorts to ExtractValue if the author is NULL:
SELECT IF(b.author IS NULL,
ExtractValue(m.metadata,
'//datafield[@tag="700"]/subfield[@code="a"]'),
b.author
)
FROM biblio b
Hi Hans,
I'm no SQL expert either, but I usually use CONCAT_WS to have the 100
and 700 authors appear in the same column.
Also, check your mappings in Administration > Koha to MARC mapping. You
may be able to use biblio.author instead of ExtractValue for the 100 field.
So something like
Hello everyone,
I would like to have a report of only fields 100 and 700 in a single
column. I'm a student and I do not understand much about sql, but I've
managed to get a 100 report through ExtractValue syntax queries (marcxml,
xpath). But I do not know how to get one of the fields 100, 700 in
3 matches
Mail list logo