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

[Eric Phetteplace]

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 at 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 at 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 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 4:47 PM Sambhunath Sahoo <sambhumlis at 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 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
>