AnsweredAssumed Answered

Left Joins in CABI

Question asked by daniel.aguair on Mar 22, 2017
Latest reply on May 29, 2017 by TMACUL

Hi everyone,

 

I have a SQL query used to perform some SQL Reports, that i need to convert into a CABI Report. Although, i'm facing some issues trying to "translate" it on CABI due to a left join between CR and ALG objects.

The main purpose is basic:
List Tickets, and in case of a ticket is resolved or closed, post the RESOLVED notes (act_log type = 'RE')...

 

So, my SQL is:
select ( ... )
alog.description 
from call_req
left join act_log alog on alog.call_req_id = call_req.persid and alog.type like 'RE'

left join act_type as typ on typ.code = alog.[type]

 

And the problem is that on my CABI query editor, it is translated to a "
Select (...)
from cr,alg (...)" and presenting all the act_log entries for each Ticket ...

 

Any idea ??

Outcomes