Forums - Thread Details
  • State Not Answered
  • Replies 3 replies
  • Subscribers 235 subscribers
  • Views 103 views
  • Users 0 members are here
Related

Duplicate records in relationship tables

shreya dalvi
15 days ago

HI ALL,

We are facing duplicate entries issue in report, as per report record are duplicate but if you search the same in Account module list view, then there is only one entry

And after debugging we found that we have relationship between Accounts and custom module and duplicate entries are there in relationship table hence, it show duplicate entries in report also.
Can anyone let us know what is the root cause for the same.
Also please suggest on how to find such entries clear it.

Relationship is : 1 custom module to Many Accounts.

Kindest Regards,

Shreya

Parents
  • 0 15 days ago

    Hello , 

    Can you share the following with us so we can have a better understanding of the question: 

    1 - Do you see duplicated entries in the relationship table in the database?

    The table name should be something like this: 
    custom_module_name_accounts_1_c

    2 - Can you share the query that your report in Sugar is generating? 

    This will help us understand if it's something with the report or with the data. 

    Looking forward to hearing from you. 

    André

  • 0 15 days ago in reply to Andre Serrazina

    Hi André,

    Thanks for responding!!

    Please see my comments below:

    1 - Do you see duplicated entries in the relationship table in the database? Yes

    2 - Can you share the query that your report in Sugar is generating?  Apology but I can't share the query.

    Kindest Regards,

    Shreya

  • 0 15 days ago in reply to shreya dalvi

    If you are seeing duplicates I would focus on the process that is creating records on that table. 

    How are you relating Accounts to your custom module? 

    Is this via Graphic User Interface, integration, import or are you using some other process? 

Reply Children
No Data