CMDBuild Forum

CQL filter -> Like "char%"

Old Versions
#1

Hello 

I have a sql query with a "like" inside. For example :

Select "Description" from class where "Code" like '123%'

Do you have any idea of how to use the "like" in the cql ?

 

Thank you !

#2

Hi,

 
if you need to make complex queries you can insert pure sql inside the cql expression like this:
 
select Description from Class where Id in (/( select "Id" from "Class" where "Code" like '123%' )/)
 
where the bold part is the pure sql innested in the cql expression.
 
Regards,
CMDBuild Team
 
 
Previously Timmy wrote:

Hello 

I have a sql query with a "like" inside. For example :

Select "Description" from class where "Code" like '123%'

Do you have any idea of how to use the "like" in the cql ?

 

Thank you !