Alternate Graphic Representation (880 Tag) Information Details stored in which Koha Database Tables?
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
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
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
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. ~~~~~~~~~~~~~~~~~~~~~~~~~~
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$_.$/}
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 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 4:47 PM Sambhunath Sahoo <sambhumlis@gmail.com> wrote:
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
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_metadata WHERE ExtractValue(metadata, '//datafield[@tag="880"]/*') <> '' If you are not seeing results, I suspect you've structured your call to ExtractValue() wrong or are looking in subfields that have no content. You can consult the documentation Thomas shared or inspect the MARCXML of a single record you expect to see in the results to see how it isn't aligning with your query. Best, ERIC PHETTEPLACE Systems Librarian, Libraries (he/him) ephetteplace@cca.edu | o 510.594.3660 (cca) 5212 Broadway | Oakland, CA | 94618 CCA is situated on the traditional unceded lands of the Ohlone peoples. Black-owned bookstores in Oakland: Ashay by the Bay <https://ashaybythebay.com/>, Marcus Books <https://www.facebook.com/marcus.books/> :(){ :|: & };: On Mon, Mar 7, 2022 at 10:23 PM Sambhunath Sahoo <sambhumlis@gmail.com> wrote:
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 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 4:47 PM Sambhunath Sahoo <sambhumlis@gmail.com> wrote:
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
participants (5)
-
Eric Phetteplace -
Indranil Das Gupta -
Mohamad F Barham -
Sambhunath Sahoo -
Thomas Klausner