[Koha] Alternate Graphic Representation (880 Tag) Information Details stored in which Koha Database Tables?

[Thomas Klausner]

Hi!

On Mon, Mar 07, 2022 at 04:47:31PM +0530, Sambhunath Sahoo wrote:

> I had already checked the Table "biblio_metadata". It has the following
> columns: id, biblionumber, format, schema, metadata, timestamp. The 880
> fields data is not visible (may be included in the metadata column?).
> Please guide me on how to fetch those fields' data.

Most of the MARC data is not stored in distinct columns in the database, 
but in an XML blob in biblio_metadata.metadata.

You should follow Mohamad Barhams suggestion to use ExtractValue to 
generate an xpath query to extract the data from the XML.
See for example here: https://dev.mysql.com/doc/refman/8.0/en/xml-functions.html

Greetings,
domm

-- 
#!/usr/bin/perl                             https://domm.plix.at
for(ref bless{},just'another'perl'hacker){s-:+-$"-g&&print$_.$/}