13
Views
13
Comments
Solved
Why i see comapny name twicw or thrice in the dropdown

Hello Team,

Under company dropdown when i try to select a company the same company name appear thrice or twice under the dropdown why is it so?


2026-01-28 16-57-48
Mihai Melencu
Champion
Solution

You should use the company attribute from the GetContactById. 

2026-01-28 16-57-48
Mihai Melencu
Champion

Hi! Check your aggregate you likely have the Company entity joined with another entity, which is causing the duplicates. Do you actually need that join, or was it added by mistake? If it’s not needed, you can just remove it. 

UserImage.jpg
Gaganashree Lohit

This this is the aggregate.

2026-01-28 16-57-48
Mihai Melencu
Champion

The issue is probably with the contact join, try deleting it and see if the issue still persists, also check if it's used anywhere.

2024-12-18 16-06-42
Junaid Syed

Hello Gaganashree,

Looking at your aggregate join it seems that this is happening because for a given company you have multiple contacts. Therefore when you perform the join between Company and Contacts entity multiple records are returned all having same company name.

Hope it helps!

Junaid 

UserImage.jpg
Gaganashree Lohit

I removed all the source except Company, and it is working as expected, Thank you Mihai. I also have a doubt that when i click on any of created contact in the Contact list, it will take to the edit contact page. As for example,consider the first one Ana, when i click on that it will take me to edit contact page, as we can observe in the comapny is Widget Corp but when clicked on that it will be nothing in the company, why it is so? I want Widget corp in the edit contact page in the company field




2026-01-28 16-57-48
Mihai Melencu
Champion

Make sure your aggregate is set to fetch on start, and that the variable used in the dropdown has the same source as the other input fields.

UserImage.jpg
Gaganashree Lohit

Mihai, since company list can only be getting in Company table not from the contact table. Hence i used Company aggregate.

UserImage.jpg
Supriya Malla

Hi @Gaganashree Lohit,

what is the variable that you have assigned for the dropdown?

UserImage.jpg
Gaganashree Lohit

Aggregate Fetch is set to "At start only."

Variable used in other fields of the eidit contact field is getting by GetContactById aggregate, but for the company i am using GetcompanybyId aggregate.

2026-01-28 16-57-48
Mihai Melencu
Champion
Solution

You should use the company attribute from the GetContactById. 

UserImage.jpg
Gaganashree Lohit
UserImage.jpg
Gaganashree Lohit

In the Contact entity i do not have Comany name attribute 

2026-01-28 16-57-48
Mihai Melencu
Champion

You don't need the name, use the CompanyId. 

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.