cancel
Showing results for 
Search instead for 
Did you mean: 

How to use NOT IN operator in filter expression editor in calculation view projection node?

former_member197081
Participant

I need to filter records based on NOT IN list function. For example

Select * from "sample_schema"."sample_table" where where STATUS NOT IN ('AWAITING','HOLD').

Accepted Solutions (1)

Accepted Solutions (1)

pfefferf
Active Contributor

You can write your expression like following:

not(in("STATUS", 'AWAITING', 'HOLD'))
former_member197081
Participant
0 Kudos

Thanks Florian, it's working. Though I'm getting error sign in the syntax. Could you please help me how to use a escape sequence in the filter expression. For example, I have a condition : Org = 'Zurich Sult's'. When I am writing the expression like ; Org = 'Zurich Sult''s' (extra single quote as escape sequence) it throwing error.

pfefferf
Active Contributor

Use a backslash as escape character instead of a single quote in the filter expression.

Former Member
0 Kudos

This is the syntax for column Engine.

Is there also a way to do it with SQL syntax?

Which one is better from a performance point?

Answers (0)