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