Lookup search SOQL error after Brooklyn update Maybe I am missing something obvious here, but I have a new error when searching within a lookup field after upgrading to the latest Brooklyn release (9.5.5) in a sandbox. Production is still on version 8.13 (I know, I’m very behind the times and have been scolded) and is not having this error.
Lookup is to the Contact object, which is the parent to the custom object record being entered. When I start typing something in the auto-complete lookup field, I get the following SOQL error:
An error occurred while attempting to perform the following SOQL query: SELECT Name,FirstName,LastName,Birthdate,Current_Age__c,Sex__c,Ethnicity__c,Primary_Language__c,Id FROM Contact WHERE ((RecordType.DeveloperName != ‘Staff’))AND(((Name LIKE ‘%test%’)OR(FirstName LIKE ‘%test%’)OR(LastName LIKE ‘%test%’)OR(Current_Age__c LIKE ‘%test%’))) ORDER BY Name LIMIT 51 Error:like operator only valid on string field
Current_Age__c is a numeric formula field. I am not sure why the SOQL would be attempting to sea