2 Replies Latest reply: Sep 6, 2011 6:35 AM by Ian Crosland RSS

SQL script error: can not be filtered in query call

Debbie Pyykkonen
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*'