---------- Forwarded message ---------- From: Peter Hartmann <peter@hartmanncomputer.com> Date: Jan 17, 2008 8:29 PM Subject: Re: [Koha-devel] Custom searches in opac To: Henri-Damien LAURENT <laurenthdl@alinto.com> Can I make the search criteria not so strict? I did notice that with my previous 952p test that partial searches didn't work. Searching for '6' did not return results although that are many sixes in barcodes. These 521a fields have spaces in them as well which may be causing a problem. Examples: PreK. - K 4 / 3 - 7 Not sure what the second one indicates....but that's the librarians doing. With name="operator" value="contains": Searching for 'prek' gives 7 results even though there are man more there. Searching for any of the numbers doesn't work. name="operator" value="=" Single numbers and floating point numbers work but not 'Prek'. Is there some way of combining "=" and "contains"? I tried using 'or' like this but no good: <input type="hidden" name="operator" value="contains" or "=" /> and also two separate lines with each variation.... thanks, Peter here it is again... <th><label for="level">Reading Level:</label></th> <td><input type="hidden" name="marclist" value="521a" /> <input type="hidden" name="and_or" value="and" /> <input type="hidden" name="excluding" value="" /> <input type="hidden" name="operator" value="contains" /> <input type="text" id="level" name="value" /> </td> </tr> On Jan 17, 2008 7:33 PM, Peter Hartmann <peter@hartmanncomputer.com> wrote:

Hey Henri-Damien , That's what this bit of code originally looked like. Just for kicks I changed it to 952b -barcode- and searched for a valid barcode. It does indeed work, just not for 521a which is populated in the aforementioned table . So does this mean that I have to link 521a with a koha-marc? Sorry this sliding in to userville.

Thanks,

Peter

On Jan 17, 2008 6:04 PM, Henri-Damien LAURENT <laurenthdl@alinto.com> wrote:

...

Hi, Peter Hartmann a écrit :

...

Hey, I'm looking to set up a custom search in the npl opac for 'Reading Level". This is a big one for elementary schools. This information is under 521a in the marc records that I have imported into koha database. This mysql query lists the information in a table that I need:

select * from marc_subfield_table where tag = 521 and subfieldcode = 'a';

Any ideas how I could search this as a temporary table from the opac. Or is there an easier way?

<th><label for="level">Reading Level:</label></th>

<td><input type="hidden" name="marclist" value="marc_subfield_table.subfieldvalue" />

try this here : value="'521a'" It should work.

...

<input type="hidden" name="and_or" value="and" /> <input type="hidden" name="excluding" value="" /> <input type="hidden" name="operator" value="contains" /> <input type="text" id="subfieldvalue" name="value" /> </td> </tr>

this is how far I've gotten in altering the opac-search.tmpl file for the npl template. It doesn't work.

So long. -- Henri-Damien LAURENT