CA Service Management

  • 1.  How create a new Object like a view

    Posted Apr 22, 2017 04:11 PM

    HI, I created a report in Jaspersoft Studio using the objects layer from CA, I need to show in my report the only last solution for a ticket. I know that it's in the object casd.alg and I join this table and casd.cr but the result is rows duplicated i need a report lke this:

     

    ticket                     last_solution

    cr.ref_num            alg.description

     

    Please help me.



  • 2.  Re: How create a new Object like a view
    Best Answer

    Posted Apr 23, 2017 10:24 PM

    Hi,

    the SQL should be something like this:

     

    select C.ref_num, A.description
      from cr C join alg A on A.call_req_id = C.persid
     where A.id in (select max(id) from alg A2
                     where A2.call_req_id = C.persid
                       and A2.type = 'SOLN')

    Regards,

    James



  • 3.  Re: How create a new Object like a view

    Posted Apr 24, 2017 12:01 PM

    Hi, It's doen´t work if I have tickets that don´t have any solution and the query doesn´t show this tickets, I need to show all tickets and show only tha last solution if it has it.



  • 4.  Re: How create a new Object like a view

    Broadcom Employee
    Posted Sep 29, 2017 05:00 PM

    Hello Rholf,

     

    Is this still something you are waiting on?

     

    thx

    _R