I'm working on a custom search page, which will search through the fields of the Project object. I use dynamic SOQL query similar to that:
String query = 'SELECT Name, Status__c ... FROM Project__c WHERE Name LIKE \'%' + String.escapeSingleQuotes(name) +'%\' + ' OR Status__c = \'' + String.escapeSingleQuotes(status) +'\''; List<Project__c> projects = Database.query(query);
But when I try to add to filter criteria Description__c field, which is Long Text Area, get the following error:
System.QueryException: field 'Description__c' can not be filtered in query call
How can I use Long Text Area fields in filtering of results?