topic SQL script error: can not be filtered in query call in QlikView

SQL script error: can not be filtered in query call

Mon, 05 Sep 2011 16:34:22 GMT

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

SQL script error: can not be filtered in query call

Mon, 05 Sep 2011 16:44:45 GMT

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

SQL script error: can not be filtered in query call

Ian_Crosland — Tue, 06 Sep 2011 10:35:38 GMT

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