hi there..... im just using the SQL given by you and its work

If you mean this query Barton provided,

SELECT ExtractValue( metadata, '//datafield[@tag=650]/subfield[@code="a"]' ) as 'Topical term', biblionumber, title FROM biblio INNER JOIN biblio_metadata using (biblionumber) WHERE ExtractValue( metadata, '//datafield[@tag=650]/subfield[@code="a"]' ) rlike '\\.'

You can append one line to that query: AND title LIKE '%mechatronics%' This will limit your query to any title with "mechatronics" anywhere in the title. -- Owen -- Web Developer Athens County Public Libraries https://www.myacpl.org

Thanks everyone for the most helpful responses! Sarah, I couldn't agree more. We should not have to mess up properly formatted records to accommodate a flaw in the system. Going to comment on 17661 right now! Tami -----Original Message----- From: Sarah B. Cornell <sbcornell@cityofportsmouth.com> Sent: Monday, March 25, 2019 12:25 PM To: Hernandez, Heather <heather_hernandez@nps.gov>; Tami Wilkerson <twilkerson@critfc.org> Cc: koha <koha@lists.katipo.co.nz> Subject: RE: [Koha] Extracting list of biblios with . in the subject Heather, This display has bothered me all along, and I can't seem to NOT see it on a regular basis! "Fixing" all the records with periods in the subject is so tempting but I'm trying to leave our MARC records in good form rather than editing them to accommodate Koha's shortcomings. I hadn't noticed that the search performed is exactly the same whether the user selects "Whales" or "Whales.". But even if they are just duplicates, I'd rather see more unique facets in that initial list and not have to select "show more" all the time! I'm going to comment on bug 17661, which proposes a fix. Anybody want to join me? :) Sarah -----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Hernandez, Heather Sent: Friday, March 22, 2019 3:57 PM To: Tami Wilkerson <twilkerson@critfc.org> Cc: koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] Extracting list of biblios with . in the subject Hi, Tami-- Ah--ours displays exactly the same way--we don't have records with the subject "Lampreys," but we do have whales: - Topics - Whales <https://keys.bywatersolutions.com/cgi-bin/koha/opac-search.pl?q=ccl=su%2Cphr%3Awhales&limit=su-to:Whales> - Whales. <https://keys.bywatersolutions.com/cgi-bin/koha/opac-search.pl?q=ccl=su%2Cphr%3Awhales&limit=su-to:Whales.> - Whaling <https://keys.bywatersolutions.com/cgi-bin/koha/opac-search.pl?q=ccl=su%2Cphr%3Awhales&limit=su-to:Whaling> - Whaling in art. <https://keys.bywatersolutions.com/cgi-bin/koha/opac-search.pl?q=ccl=su%2Cphr%3Awhales&limit=su-to:Whaling in art.> - Whaling. <https://keys.bywatersolutions.com/cgi-bin/koha/opac-search.pl?q=ccl=su%2Cphr%3Awhales&limit=su-to:Whaling.> - Show more <https://keys.bywatersolutions.com/cgi-bin/koha/opac-search.pl?q=ccl=su%2Cphr%3Awhales&expand=su-to#su-to_id> This display used to bother me, but at least in our catalog, if the user selects either one, they retrieve the same record set--selecting the one without the ending period retrieves the exact same 513 results as selecting the one with the ending period--at least in our catalog. I try to calm my Inner Cataloger and not look at this display too often.:) I don't know if there's a way to have the whole string appear in that facet area--the facet area is pretty small! I think if a user wanted to click/tap through subject headings that included subdivisions, they'd need to do that after they select a record to display--i.e., from the "Normal view" of one record. But I'm no Koha display expert by a LONG shot--those on the list who are might have some helpful ideas/suggestions! Keep asking questions--we all learn something when people ask questions! Glad you've joined us in this friendly community! Cheerio! h2 ~~~~~~~~~~~~~~ Heather Hernandez (she, her, hers) Technical Services Librarian San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 415-561-7032, heather_hernandez@nps.gov Library catalog: http://keys.bywatersolutions.com/ _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Well, my next mission is to ask for a quote then ask my boss. But I hear you loud and clear! :) Sarah -----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Chris Cormack Sent: Monday, March 25, 2019 6:02 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Extracting list of biblios with . in the subject Awesome! Now someone just has to be funded to work on it. People always want to fix bugs, but we have to work on what we are paid to do. So there's the next mission should you choose to accept it :) Chris On 26 March 2019 8:53:54 AM NZDT, Tami Wilkerson <twilkerson@critfc.org> wrote:

Thanks everyone for the most helpful responses!

Sarah, I couldn't agree more. We should not have to mess up properly formatted records to accommodate a flaw in the system. Going to comment on 17661 right now!

Tami

-----Original Message----- From: Sarah B. Cornell <sbcornell@cityofportsmouth.com> Sent: Monday, March 25, 2019 12:25 PM To: Hernandez, Heather <heather_hernandez@nps.gov>; Tami Wilkerson <twilkerson@critfc.org> Cc: koha <koha@lists.katipo.co.nz> Subject: RE: [Koha] Extracting list of biblios with . in the subject

Heather,

This display has bothered me all along, and I can't seem to NOT see it on a regular basis! "Fixing" all the records with periods in the subject is so tempting but I'm trying to leave our MARC records in good form rather than editing them to accommodate Koha's shortcomings.

I hadn't noticed that the search performed is exactly the same whether the user selects "Whales" or "Whales.". But even if they are just duplicates, I'd rather see more unique facets in that initial list and not have to select "show more" all the time!

I'm going to comment on bug 17661, which proposes a fix. Anybody want to join me? :)

Sarah

-----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Hernandez, Heather Sent: Friday, March 22, 2019 3:57 PM To: Tami Wilkerson <twilkerson@critfc.org> Cc: koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] Extracting list of biblios with . in the subject

Hi, Tami--

Ah--ours displays exactly the same way--we don't have records with the subject "Lampreys," but we do have whales:

- Topics

- Whales <https://keys.bywatersolutions.com/cgi-bin/koha/opac-search.pl?q=ccl=su%2Cphr%3Awhales&limit=su-to:Whales> - Whales. <https://keys.bywatersolutions.com/cgi-bin/koha/opac-search.pl?q=ccl=su%2Cphr%3Awhales&limit=su-to:Whales.> - Whaling <https://keys.bywatersolutions.com/cgi-bin/koha/opac-search.pl?q=ccl=su%2Cphr%3Awhales&limit=su-to:Whaling> - Whaling in art. <https://keys.bywatersolutions.com/cgi-bin/koha/opac-search.pl?q=ccl=su%2Cphr%3Awhales&limit=su-to:Whaling in art.> - Whaling. <https://keys.bywatersolutions.com/cgi-bin/koha/opac-search.pl?q=ccl=su%2Cphr%3Awhales&limit=su-to:Whaling.> - Show more <https://keys.bywatersolutions.com/cgi-bin/koha/opac-search.pl?q=ccl=su %2Cphr%3Awhales&expand=su-to#su-to_id>

This display used to bother me, but at least in our catalog, if the user selects either one, they retrieve the same record set--selecting the one without the ending period retrieves the exact same 513 results as selecting the one with the ending period--at least in our catalog. I try to calm my Inner Cataloger and not look at this display too often.:)

I don't know if there's a way to have the whole string appear in that facet area--the facet area is pretty small! I think if a user wanted to click/tap through subject headings that included subdivisions, they'd need to do that after they select a record to display--i.e., from the "Normal view" of one record.

But I'm no Koha display expert by a LONG shot--those on the list who are might have some helpful ideas/suggestions!

Keep asking questions--we all learn something when people ask questions! Glad you've joined us in this friendly community!

Cheerio! h2 ~~~~~~~~~~~~~~ Heather Hernandez (she, her, hers) Technical Services Librarian San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 415-561-7032, heather_hernandez@nps.gov Library catalog: http://keys.bywatersolutions.com/ _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

-- Sent from my Android device with K-9 Mail. Please excuse my brevity. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha