CA Service Management

  • 1.  Left Joins in CABI

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



  • 2.  Re: Left Joins in CABI

    Broadcom Employee
    Posted Mar 22, 2017 02:20 PM

    Daniel.........

     

    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 May 29, 2017 01:13 PM