Hello,
I want to create a Koha report which includes *Alternate Graphic
Representation (880 Tag)* Information Details stored in its Database
Tables. I checked all 222 database tables of Koha (Version 21.05)
like biblio, biblioitems, etc. but was not able to identify where the above
said information
Hi Sambhunath,
Table is biblio_metadata
With regards
-idg
On Mon, 7 Mar, 2022, 3:12 pm Sambhunath Sahoo, wrote:
> Hello,
> I want to create a Koha report which includes *Alternate Graphic
> Representation (880 Tag)* Information Details stored in its Database
> Tables. I checked all 222 databas
Hi Indranil,
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.
Regards,
Dr. Sambh
nate Graphic Representation (880 Tag) Information
Details stored in which Koha Database Tables?
Hi Indranil,
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
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?).
> Pleas
Hi Indranil,
I am able to fetch 880 Tags data from biblio_metadata table.
Thanks
Regards,
Dr. Sambhunath Sahoo / डॉ सम्भुनाथ साहु
Assistant Librarian / सहायक पुस्तकालयाध्यक्ष,
Central Library / केन्द्रीय पुस्तकालय,
4th Floor, Administrative Building / चौथा मंजिल, प्रशासनिक भवन
Indian Institute of
Hi Sambhunath,
Could you share the report's SQL? It's easier to find what is going wrong
if we can see the query.
This will show the full 880 field for every record that has one in your
catalog:
SELECT biblionumber, ExtractValue(metadata, '//datafield[@tag="880"]/*') as
'880 field'
FROM biblio_m
7 matches
Mail list logo