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

[Mohamad F Barham]

Hi,

you can use this in your select statement

ExtractValue(metadata, '//datafield[@tag="888"]/subfield[@code="a"]') AS data,





Mohamad Barham

System Engineer | Information Technology Department

Birzeit University

P.O.Box. 14, Birzeit, Palestine

Tel: + 970 22982012 | Mob: +970 597 861929 | Ext: 5616

mbarham at birzeit.edu | www.birzeit.edu<http://www.birzeit.edu/>





________________________________
From: Koha <koha-bounces at lists.katipo.co.nz> on behalf of Sambhunath Sahoo <sambhumlis at gmail.com>
Sent: Monday, March 7, 2022 1:17 PM
To: Indranil Das Gupta <indradg at gmail.com>
Cc: koha <koha at lists.katipo.co.nz>
Subject: Re: [Koha] Alternate 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 the metadata column?).
Please guide me on how to fetch those fields' data.

Regards,
Dr. Sambhunath Sahoo / डॉ सम्भुनाथ साहु
Assistant Librarian / सहायक पुस्तकालयाध्यक्ष,
Central Library / केन्द्रीय पुस्तकालय,
4th Floor, Administrative Building / चौथा मंजिल, प्रशासनिक भवन
Indian Institute of Technology Bhubaneswar / भारतीय प्रौद्योगिकी संस्थान
भुवनेश्वर
Argul, Khurda, Odisha /  आरगुल, खुर्दा, ओड़िशा,
752050 (India)
Mobile: 7978949882
Phone: +91-674-713-8756 (O)
E-Mail: sambhu at iitbbs.ac.in
           sambhumlis at gmail.com
*ORCID ID:* 0000-0001-9162-879X
*Researcher ID:* K-4446-2018
*Scopus ID:* 57222542160



On Mon, Mar 7, 2022 at 3:51 PM Indranil Das Gupta <indradg at gmail.com> wrote:

> Hi Sambhunath,
>
> Table is biblio_metadata
>
> With regards
> -idg
>
> On Mon, 7 Mar, 2022, 3:12 pm Sambhunath Sahoo, <sambhumlis at gmail.com>
> 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 database tables of Koha (Version 21.05)
>> like biblio, biblioitems, etc. but was not able to identify where the
>> above
>> said information (Title, subtitle in other language, and Statement of
>> Responsibility in other language) are stored. Please guide me which Koha
>> DatabaseTable stores the information of 880 Tags (880$a, 880$b, 880$c)?
>>
>> Regards,
>> Dr. Sambhunath Sahoo / डॉ सम्भुनाथ साहु
>> Assistant Librarian / सहायक पुस्तकालयाध्यक्ष,
>> Central Library / केन्द्रीय पुस्तकालय,
>> 4th Floor, Administrative Building / चौथा मंजिल, प्रशासनिक भवन
>> Indian Institute of Technology Bhubaneswar / भारतीय प्रौद्योगिकी संस्थान
>> भुवनेश्वर
>> Argul, Khurda, Odisha /  आरगुल, खुर्दा, ओड़िशा,
>> 752050 (India)
>> Mobile: 7978949882
>> Phone: +91-674-713-8756 (O)
>> E-Mail: sambhu at iitbbs.ac.in
>>            sambhumlis at gmail.com
>> *ORCID ID:* 0000-0001-9162-879X
>> *Researcher ID:* K-4446-2018
>> *Scopus ID:* 57222542160
>> _______________________________________________
>>
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
_______________________________________________

Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
~~~~~~~~~~~~~~~~~~~~~~~~~~
The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. The University is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.
~~~~~~~~~~~~~~~~~~~~~~~~~~