Clarity Service Management

Expand all | Collapse all

Left Joins in CABI

  • 1.  Left Joins in CABI

    Posted 03-22-2017 01:24 PM

    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 ( ... )
    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 ??

  • 2.  Re: Left Joins in CABI

    Posted 03-22-2017 02:20 PM



    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)

  • 3.  Re: Left Joins in CABI

    Posted 05-29-2017 01:13 PM