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 !
Hi sanketkumar.d ,
You need to know the universe and the database, which CABI are you using?
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 .
How are you doing this select?
Which tables do you have selected?
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.
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.
select *from call_reqwhere dateadd(ss, open_date, '19700101') > '20151001'
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.
Hi , There was an object from different table and we removed it and now its woking fine . Thanks a lot
HI sanketkumar.d ,
Please , mark the correct anwser, help us to improve the CA Communities.