CA Service Management

Expand all | Collapse all

Last activity description CABI 4.1

Jump to Best Answer
  • 1.  Last activity description CABI 4.1

    Posted 09-25-2017 01:43 PM

    Hello !

     

     

    I have a few reports on CABI 14.1 and i require the last activity log of the tickets in a colum 

     

     

    I used the Action description of Request activity folder but it berings me all the changes of each ticket and i one need the last one

     

    Do you know how displays that field or what is the query that i must use ?

     

     

     

    Regards



  • 2.  Re: Last activity description CABI 4.1

    Broadcom Employee
    Posted 09-27-2017 04:56 PM

    Christian,

     

    You could try to look for all Action Descriptions (of a given ticket) with the latest last_mod_dt  or highest id   (higest act_log.id  or highest alg.id )

     

    _R



  • 3.  Re: Last activity description CABI 4.1

    Posted 09-27-2017 06:07 PM

    But I need to do it in CABI not in the SQL studio , by the moment displays all the action logs ,  i tried with a formula but dont  show me the last description of active log 



  • 4.  Re: Last activity description CABI 4.1

    Broadcom Employee
    Posted 09-28-2017 10:29 AM

    1) You'd definitely need a join between Request Activity class ->  Call Request ID    and    Request Details -> ID   

    2) Then you'd need the a CABI function like maximum(Request Activity class -> ID)  See this:  (https://communities.ca.com/message/116975088?commentID=116975088#comment-116975088 ) 

     

    _R



  • 5.  Re: Last activity description CABI 4.1

    Posted 09-28-2017 02:03 PM

    The join between Request Activity class -> Call Request id and Request Details id need to do in SQL ? then i need to use the CABI function maximum?



  • 6.  Re: Last activity description CABI 4.1

    Broadcom Employee
    Posted 09-28-2017 03:23 PM


  • 7.  Re: Last activity description CABI 4.1

    Posted 09-29-2017 10:39 AM

    Hi Raghu !

     

    But i dont know what is  the sintax of the condition of maximum or higest   alg.iaction_desc for cr.id

     

    Can you help me with that?

     

    Thanks for your help

     

    Now i have this Query 

     

    SELECT
    cr.type_symbol,
    cr.tenant_name,
    cr.ref_num,
    cr.request_area_symbol,
    cr.assignee_combo_name,
    cr.open_date,
    cr.summary,
    cr.status_symbol,
    cr.last_mod_dt,
    alg.action_desc
    FROM
    cr,
    alg
    WHERE
    (
    cr.active = 1
    AND
    cr.id = alg.id

     

     

    )

     

     

     

    Regards



  • 8.  Re: Last activity description CABI 4.1
    Best Answer

    Broadcom Employee
    Posted 09-29-2017 12:36 PM

    Sorry slapping on something really basic here if that helps - 

     

     

    select cr.ref_num, cr.type_symbol, alg.action_desc

    from cr, alg

    where alg.id=(select max(alg1.id) from alg alg1 where alg1.call_req_id = cr.persistent_id)

    and alg.call_req_id = cr.persistent_id

     

    _R



  • 9.  Re: Last activity description CABI 4.1

    Posted 09-29-2017 12:46 PM

    Thaks for the help  Raghu , 

     

    Sorry for the lack of knowledge



  • 10.  Re: Last activity description CABI 4.1

    Posted 09-29-2017 01:45 PM

    Hi Christian,

    If Raghu's previous post has helped, can you please just go ahead and mark that as the answer on this one?

    Thanks,

    Jon I.



  • 11.  Re: Last activity description CABI 4.1

    Broadcom Employee
    Posted 09-29-2017 02:19 PM

    oh no problem at all.   I'm not sure about the performance of the query with huge amount of data though. You may need to tweak it a bit per need

    _R