cancel
Showing results for 
Search instead for 
Did you mean: 
Masaru_Asano
Cosmonaut
Status: Needs Info

I think this function is useful for realizing aggregation with complex conditions such as subqueries on the dashboard without modifying the schema.

3 Comments
Status changed to: Needs Info
JoeM
Community Manager
Community Manager

Hi @Masaru_Asano ,

I'm curious to hear more about what you are looking for here. "Not In" should be available as a dashboard-level operator.

JoeM_0-1687526528432.png

RADSr
Partner
Partner

I suspect ( and agree if it's the case ) that this refers to something like:

==================

WHERE 1 = 1  

AND  <Column> NOT IN ( select <Column> where <interesting condition exists> ) 

===================

Being able to filter on a subquery / result set would be a hugely valuable feature addition! 

Masaru_Asano
Cosmonaut

Yes, there is an "in query" filter that corresponds to a subquery of incorta. Currently, however, it is not possible to specify "not in query", which is the negation of "in query", and it is necessary to define a derived table in the schema that corresponds to the subquery.