CMDBuild Forum

NOT IN ( CQL )

Old Versions
#1

Hello,

I want to know how to express "NOT IN" with CMDB QUERY LANGAGE

 

Regards.

#2
Dear Surridge,
 
Since nobody answer after a long time let me give it a try.Instead of thinking the glass as half empty, why not think of it as half full.
 
instead of::
 
from Class
where Id not in (/(
select "Id" from "Class" 
Where "TheStatus"='Ok'
)/)
 
you do this::
 
from Class
where Id in (/(
select "Id" from "Class" 
Where "TheStatus"<>'Ok'
)/)
 
 
 
Previously Surridge wrote:

Hello,

I want to know how to express "NOT IN" with CMDB QUERY LANGAGE

 

Regards.