Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
BlueteeBluetee 

try to select using condition ' where Descrption = 'Test' '

Hello,
 
we use query string: select id from account where Description='Test' to query. And caught the following error:
INVALID_FIELD: field 'Description' can not be filtered in query call
 
does it mean there is a banch of columns which could not be used in query? if so, are there a list of those fields? and how could I find it.
 
Thanks!
SuperfellSuperfell
Certain field types can't be used in a SOQL filter, this information is exposed via the describeSObject call (see the filterable flag on Field), and tools like ApexExplorer and SoqlXplorer will show this.