02-22-2017 3:35 PM - edited 02-03-2024 6:25 PM
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').
You can write your expression like following:
not(in("STATUS", 'AWAITING', 'HOLD'))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Use a backslash as escape character instead of a single quote in the filter expression.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.