Thanks - I will give that a try! Geoff
>>> "Whalen, Liam" <[email protected]> 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 [email protected] Web: http://www.nrcan.gc.ca/library/
