Fwd: [Koha-devel] Custom searches in opac

[Peter Hartmann]

---------- Forwarded message ----------
From: Peter Hartmann <address@hidden>
Date: Jan 17, 2008 8:29 PM
Subject: Re: [Koha-devel] Custom searches in opac
To: Henri-Damien LAURENT <address@hidden>


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 <address@hidden> 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 <address@hidden> 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
> >
>