Thread Details
  • State Not Answered
  • Replies 3 replies
  • Subscribers 354 subscribers
  • Views 655 views
  • Users 0 members are here
Forum Actions
Related

Duplicate records in relationship tables

shreya dalvi

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 Sugar Employee Badge

    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é

Reply
  • 0 Sugar Employee Badge

    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é

Children