CMDBuild Forum

JOIN IN CQL FILTER

hi, 

I'm trying to make a cql with join to get out of a process the name of the company related but I do not return any results? 

What is the right command to perform for a join?

 

filter: {"CQL":"from IncidentMgt LEFT JOIN Company ON Company.Id=IncidentMgt.Company where Number=\'IM002900\'"}

 

Thanks