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 [email protected] | www.birzeit.edu<http://www.birzeit.edu/> ________________________________ From: Koha <[email protected]> on behalf of Sambhunath Sahoo <[email protected]> Sent: Monday, March 7, 2022 1:17 PM To: Indranil Das Gupta <[email protected]> Cc: koha <[email protected]> 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: [email protected] [email protected] *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 <[email protected]> wrote: > Hi Sambhunath, > > Table is biblio_metadata > > With regards > -idg > > On Mon, 7 Mar, 2022, 3:12 pm Sambhunath Sahoo, <[email protected]> > 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: [email protected] >> [email protected] >> *ORCID ID:* 0000-0001-9162-879X >> *Researcher ID:* K-4446-2018 >> *Scopus ID:* 57222542160 >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> [email protected] >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> > _______________________________________________ Koha mailing list http://koha-community.org [email protected] 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~ _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
