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_reqleft 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 ??
Have you configured CABI Join Parameters as documented at: Integrate CA Service Desk Manager with CA Business Intelligence - CA Service Management - 14.1 - CA Technologies Documen… (refer to the How to Configure Date Range Values and Join Parameters)
Get better performance using:
CABI4::. CA Bussiness Intelligence: Building a Subquery report