Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

SQL script error: can not be filtered in query call

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*'
Tags (1)
2 Replies
Not applicable

SQL script error: can not be filtered in query call

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

Employee
Employee

SQL script error: can not be filtered in query call

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

Community Browser