CMDBuild Forum

how to express not null in CQL

Old Versions
#1

Dear CMDBuild Team

how can I express null in CQL.For example:

 from Employee where Description is null

I want to query the Employees whose "Decription" is null,but I cannot query the informating want I want.

So thanks for you help.

#2
Hi Sudan,
you can use an SQL injection into CQL code, for example:
from Employee where Id in (/( select "Id" from "Employee" where "Description" is not null and "Status" = 'A' )/)
 
Regards,
CMDBuild Team

 

#3
I can solve the problem by your answer.Thanks a lot.
 
Previously Tecnoteca wrote:
Hi Sudan,
you can use an SQL injection into CQL code, for example:
from Employee where Id in (/( select "Id" from "Employee" where "Description" is not null and "Status" = 'A' )/)
 
Regards,
CMDBuild Team