CMDBuild Forum

CQL Filter : operator OR

Old Versions
#1

Hello,

 

I am using a reference (attribute) in my class.

I am trying to do a CQL query :

 

from my_mother_class where attribute='Hello' OR attribute='Hi'

 

But it's not working at all. Do you have an idea how to use the " OR " ?

 

Thank you

 

#2

Hi, 

we suggest to use nested SQL.
The syntax is:
 from my_mother_class where Id in (/( select "Id" from my_mother_class where attribute='Hello' OR attribute='Hi' )/)
 
Best regards.
The CMDBuild Team