Jump to content


Photo

Running report create duplicate results

report duplicates

  • Please log in to reply
12 replies to this topic

#1 wannabe

wannabe

    Member

  • Members
  • PipPip
  • 17 posts

Posted 05 July 2014 - 10:07 AM

Hi,

 

When I create a report on opportunities and add

 

Notes >> ID

or

Notes >> Created By User

or any other Notes >>

 

it will create duplicate results.

 

I checked on demo site and it is doing exactly the same

 

I did the following :

Report on module opportunities add filter last 7 days

then columns

Owner

ID

Notes >> ID

Notes >> Created By User

 

is this normal behaviour?



#2 wannabe

wannabe

    Member

  • Members
  • PipPip
  • 17 posts

Posted 07 July 2014 - 11:11 AM

nobody that can elaborate on this?



#3 speixoto

speixoto

    Advanced Member

  • Members
  • PipPipPip
  • 386 posts

Posted 07 July 2014 - 01:48 PM

What do you mean by duplicate results? Can you provide the exact details on the report you created (type of report, filters, display columns, ...)?



#4 wannabe

wannabe

    Member

  • Members
  • PipPip
  • 17 posts

Posted 07 July 2014 - 02:02 PM

Hi speixoto,

 

I already gave exact details on how to recreate the duplicates. But I will give it once more, please use demo site and create a new report on opportunities.

 

* add filter last 7 days

then in columns add the following

 

Owner

ID

Notes >> ID

Notes >> Created By User

 

You will notice that the report will create duplicate results

 

rgds,

 

J.



#5 speixoto

speixoto

    Advanced Member

  • Members
  • PipPipPip
  • 386 posts

Posted 07 July 2014 - 02:41 PM

After running the report you mention i get the above results. Can you point me where there are the duplicated ones?

h_1404744183_1725096_cf2bcbf3b7.png



#6 wannabe

wannabe

    Member

  • Members
  • PipPip
  • 17 posts

Posted 07 July 2014 - 06:06 PM

Well, look at the first column "ID" many ID's are repeating. If you would add Notes-> Description, this will be repeated 2-3 and sometimes 4 - times. Or just show empty results..

 

ID #1  is repeating 7 times .. there are your duplicates. 

 

And who and what is 'unnamed' user ??



#7 speixoto

speixoto

    Advanced Member

  • Members
  • PipPipPip
  • 386 posts

Posted 07 July 2014 - 06:52 PM

Its not repeated. The thing is, has an opportunities can have many notes, it will list every pair OpportunityID / Note ID, that is why the ID of opportuniy gets repeates, because the same opportunity #1 has 7 notes. And because this is a rows and columns report (we are not making any summation / aggregation) it show all those. This is not a bug. Dont know exactly what you plan to achieve with your report, maybe what you are trying to achieve can be done with a summation report with some sort of drill down to show related notes?

 

As for the (unnamed) user is someone who has no name. :P My guess for that unnammed and negative ids for notes is something with the demo data not working right. :|



#8 wannabe

wannabe

    Member

  • Members
  • PipPip
  • 17 posts

Posted 07 July 2014 - 08:15 PM

there are duplicates, and on my system I also have 'unnamed' user, and I for sure have NO unnamed user.

 

For example, opportunity ID #5 has duplicates. Same owner, same modified user with same description (twice) on exactly the same date and hour and minute. On my own system I have 1 opportunity with 1 note, which is repeated several times.

 

screenshot below is from demo site.

 

h_1404764144_2721958_c489d86be4.png

 

 



#9 wannabe

wannabe

    Member

  • Members
  • PipPip
  • 17 posts

Posted 07 July 2014 - 08:22 PM

Perhaps the image below is a better example

 

Report below is created on NOTES instead of OPPORTUNITIES.

 

On my system I have exactly the same problem. How do I filter redundant notes out? or fix the problem , bcs clearly it is a problem. Pay attention to some of the lines which are connected to an opportunity and some are not.... whats that about? and pay attention to opportunities ID, it jumps from a negative number to a positive one.. ??

 

h_1404764630_4547751_6bfc6ca55d.png

 

 

 



#10 speixoto

speixoto

    Advanced Member

  • Members
  • PipPipPip
  • 386 posts

Posted 07 July 2014 - 08:47 PM

Bug reported, you can track it here: https://www.pivotalt...y/show/74555982



#11 speixoto

speixoto

    Advanced Member

  • Members
  • PipPipPip
  • 386 posts

Posted 09 July 2014 - 04:34 PM

We changed so those negative number dont appear again.

You you still get duplicated results due the fact of notes/tasks/meetings are all activityItems, so, the ones with negatives number where task/meetings. If you dont want the duplicated results just run a filter and make sure opportunitues->notes->descriptions is not null.



#12 wannabe

wannabe

    Member

  • Members
  • PipPip
  • 17 posts

Posted 10 July 2014 - 09:33 AM

Great, how do i upgrade?



#13 speixoto

speixoto

    Advanced Member

  • Members
  • PipPipPip
  • 386 posts

Posted 10 July 2014 - 12:38 PM

It will be released on the 2.7.4. But to avoid the extra duplicated lines you just need to add a filter as i told, you dont need to upgrade anything.







Also tagged with one or more of these keywords: report, duplicates

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users