Skip to Content
1

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

Feb 22, 2017 at 03:35 PM

2.1k

avatar image

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').

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Florian Pfeffer
Feb 22, 2017 at 04:26 PM
1

You can write your expression like following:

not(in("STATUS", 'AWAITING', 'HOLD'))
Show 3 Share
10 |10000 characters needed characters left characters exceeded

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.

0

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

1

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?

0