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