+ Start a Discussion

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

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.
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.