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$_.$/}