[OPEN-ILS-GENERAL] Report Assistance

[Whalen, Liam]

>> -----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/