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) [email protected] | 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 <[email protected]> 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: [email protected] > [email protected] > *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 <[email protected]> > 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: [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 > _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
