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 ( ... )
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 "
from cr,alg (...)" and presenting all the act_log entries for each Ticket ...
Any idea ??