CA Service Management

 View Only
  • 1.  How to avoid Duplicate rows in report ?

    Posted Dec 28, 2016 12:13 AM

    Our status report has various fields including open date , acknowledge date , end user details, module , response time , request area , etc .

    We are encountering duplicate rows for a specific request area say A. So for all the other request areas , the details are entered only once in a report when a ticket is raised . But for the request area "A" , we get three entries(3 rows) for a single ticket .  "Avoid duplicate row aggregation" is checked yes but still the issue isnt resolved . Kindly help !

     



  • 2.  Re: How to avoid Duplicate rows in report ?

    Posted Jan 03, 2017 09:10 PM

    Hi sanketkumar.d ,

     

     You need to know the universe and the database, which CABI are you using?

    CABI3

    CABI4

    CABI6.

     

    Regards

    Tiago Macul



  • 3.  Re: How to avoid Duplicate rows in report ?

    Posted Jan 04, 2017 11:25 PM

    We are currently using CABI3 .

     

    The problem we are facing is given below:

    Ref Num.         Assignee         Opendate

    222                  Sam                  21/09/2016      12:18

    222                  Sam                  31/09/2016      13:19

    333                  Ram                  02/09/2016      13:27

     

    We want to filter out the rows with duplicate Ref. number .



  • 4.  Re: How to avoid Duplicate rows in report ?

    Posted Jan 05, 2017 07:02 AM

    Hi sanketkumar.d ,

     

       How are you doing this select?

     

       Which tables do you have selected?

     

     

    Regards



  • 5.  Re: How to avoid Duplicate rows in report ?

    Posted Jan 09, 2017 12:42 AM

    We are only using Call_Req table. And the query filters are:

    i. Open date should be greater than Oct 1 2015 

    ii. Status should be Open , Acknowledged .

    iii. Type is equal to Request.



  • 6.  Re: How to avoid Duplicate rows in report ?
    Best Answer

    Posted Jan 09, 2017 03:42 PM

    sanketkumar.d ,

     

    I'm speaking abou database, whatever you need to do, it's necessarily looking for database. The CA help us to don't make some mistakes but sometimes this happens, and all do you need is: know how DB works.

     

     

    1. CALL_REQ

    2. ACT_LOG
    3. dateadd(ss, CALL_REQ.open_date, '19700101') > '20151001'
    4. CALL_REQ.type = 'R'
    5.  

      select *
      from call_req
      where dateadd(ss, open_date, '19700101') > '20151001'

      and CALL_REQ.type = 'Rand status in ('OP', 'ACK')

     

    Therefore you select some field where bring other table, how to find it?

     

    On query panel, last icon :

     

     

    You'll looking for "database select", can you see "alg" object/table?

     

    Do you see more object than cr/call_req?

     

     

     

    The fields are available on the same order than panel, try to remove some one where don't show cr object.

     

    Regards

    Tiago Macul



  • 7.  Re: How to avoid Duplicate rows in report ?

    Posted Jan 10, 2017 01:55 AM

    Hi , There was an object from different table and we removed it and now its woking fine . Thanks a lot  



  • 8.  Re: How to avoid Duplicate rows in report ?

    Posted Jan 10, 2017 06:58 AM

    HI sanketkumar.d ,

     

      Please , mark the correct anwser, help us to improve the CA Communities.

     

    Regards