Re: [Koha] Regarding SQL query for Analytical entries

Suresh, Unfortunately, there's not a great way to do this -- the problem is that repeated tags in marcxml are extracted as a single value by ExtractValue. Here's what the Koha wiki has to say in the matter: Note that ExtractValue concatenates multiple tags into a single field. These can be indivi

Re: [Koha] OPAC search limiting options

Hi Irma, Thanks for your info. Thanks & regards, *Peter Lau* Librarian Tel: (852) 3977 9868 | Email: peter@yccece.edu.hk | Fax: (852) 23384320 [image: https://docs.google.com/uc?export=download&id=1wiYZQsqhNTJZjyNbLJx-6ODZyoYE5NNu&revid=0BzpPRj4UE0XeT1R2WUt2dnhmTFBBeEpVR3dqcU5QbnF6NVg4

Re: [Koha] Elasticsearch in Koha 18.11

Hi Ere, Thanks for your suggestion. The root cause of the issue was I installed the latest version Elasticsearch, 6.5. This version does not work with Koha 18.11, Based on the wiki, I should use Elasticsearch 5.5.x. So I installed the version 5.5.x. It works now. BR, Chee -- Sent from: ht

[Koha] Regarding SQL query for Analytical entries

Hi, we have analytical entries created for conference papers purchased in our library. We generated a report using the below query. But, unable to get the report the way I need. I wanted a separator between the subject entries that are repeated. But the separator is not getting added and all the s

Re: [Koha] OPAC search limiting options

Hi Peter, The Publication date option for search filtering is available for both system preferences : *OpacAdvSearchMoreOptions* and *OpacAdvSearchOptions*. Also define in *OPACdefaultSortOrdersort* the sort order for date of publication in this* OPACdefaultSortField *system preference*. * Hope t

[Koha] OPAC search limiting options

In OPAC, for searching limiting, can I add Year of Publication as one of the options. Currently, there’re the following options: 1. Availability2. Authors3. Item types4. Locations5. Series6. Topics Thanks & regards, *Peter Lau* Librarian Tel: (852) 3977 9868 | Email: pe