SQL script error: can not be filtered in query call

[#1]

I am not sure why i cannot filter using the NewValue field.  If I remove NewValue and just filter by Field, the query runs.   Any suggestions?

^
ERROR at Row:10:Column:29
field 'NewValue' can not be filtered in query call

LOAD

CaseId,
CreatedById,
CreatedDate,
Field,
Id,
IsDeleted,
NewValue,
OldValue;

SQL SELECT
CaseId,
CreatedById,
CreatedDate,
Field,
Id,
IsDeleted,
NewValue,
OldValue
FROM CaseHistory
Where (Field = 'Status' and NewValue = 'Closed') or
(Field = 'SubStatus' and (NewValue = 'Solved' or NewValue = 'Non-Compliant')) or
Field ='*Reason*'

[#2]

FYI - this is reading to Salesforce.com from QV10 using salesforcedll.dll(64) connection

[Ian_Crosland]

Hi

from the Salesforce API which the connector uses to extract data:

http://www.salesforce.com/us/developer/docs/api/index.htm

the NewValue field does not have Filter properties enabled to allow a where clause statement in the SOQL, you will have to extract the data to a qvd file and use a where clause on that result set.

thanks

Ian