[OPEN-ILS-GENERAL] Report Assistance

[Geoff Brown]

Thanks - I will give that a try!

Geoff

>>> "Whalen, Liam" <Liam.Whalen at NRCan-RNCan.gc.ca> 7/27/2011 3:24 PM
>>>
>> -----Original Message-----
>> What Operator are you using to check the Call Number range, 
>> and what range are you using for you Call Numbers
> 
> Base Filters:
> Filter Field: Call #/Volume
> Field transform:  Raw Data
> Operator: Contain matching substring
> 
> Because we chose the operator: contain matching substring we 
> are searching LT and LT- (the common call number we assign 
> all laptops). And this is the error:
> 
> 	DBD::Pg::st execute failed: ERROR: operator does not exist:
> bigint ~~ unknown LINE 6: ...
> "2bc58ff2e41a1dbaf4563d6aa271db78"."call_number" LIKE '%LT-... ^
HINT:
> No operator matches the given name and argument type(s). You 
> might need to add explicit type casts. at 
> /openils/bin/clark-kent.pl line 217. 

I am not sure what that error means.  However, you could limit your
search to fields containing just 'LT' that should retrieve both LT and
LT-.  If that doesn't work, you could change the operator to 'In List',
and list all your laptop Call Numbers in a comma separated list as the
Value operand.  Not sure how many laptop call numbers you have, so that
might not be feasible, although it would prevent false positives because
searching for just 'LT' might hit LCC subclass 'LT' textbooks, if you
are using Library of Congress.

Liam

Natural Resources Canada Library / Bibliothèque de Ressources
naturelles Canada
615 rue Booth Street, 121, Ottawa, ON, Canada
K1A 0E9
Telephone / Téléphone : 613-996-4180
lwhalen at nrcan-rncan.gc.ca 
Web: http://www.nrcan.gc.ca/library/