• Robert Morgenstern
  • NEWBIE
  • 0 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

I try do a query on Solution object. It complains that SolutionNote cannot be filtered in query call. Does anyone know how to make it work? Thanks.

 

binding.query("select SolutionName, SolutionNote from Solution where Key_Words__c like '%" + keyWord + "%' or SolutionName like '%" + keyWord +"%'");

 

{"INVALID_FIELD: \nor SolutionName like '%du%' or SolutionNote like '%du%'\n                               ^\nERROR at Row:1:Column:111\nfield 'SolutionNote' can not be filtered in query call"}

  • March 18, 2009
  • Like
  • 0