How to add fields to display on Duplicate Check screen?

Hello, does anybody know how I can add more fields to this duplicate check screen?

It is actually on a custom module: Case Attachments. We often have files of the same name in here and I would like to add the Case Number / (or Case 'Subject') to display in the list.

Is it a code change? I didn't find anything via admin?

Many thanks,
Luke :-)

Enterprise. Cloud. Version 11.1.0.

0 Jeroen Somhorst over 3 years ago

Hi luke,

can you take a look at here: https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_11.0/Architecture/Duplicate_Check/#Vardef_Settings. It should explain exactly what you want. (or at least how to accomplish it)
0 Luke Ridgway over 3 years ago in reply to Jeroen Somhorst

Hi Jeroen Somhorst,

Thanks for the link... I did look over that before posting here. I thought it was explaining how to add fields that will be USED to dupe check on? I am trying to simply add some fields to that list view. Like you would do for the normal module list view via studio > [module] > layouts > list view/etc,etc...

I will take another look.

Hoped it would be something I simply missed in admin ;-)
0 Alex Nassi over 3 years ago

Luke Ridgway - I found an Enhancement Request (#75648) that requests this functionality but also references that "The code for the Find Duplicates list view style layout can be found in ./modules/{Module}/clients/base/views/dupecheck-list/dupecheck-list.php."

I hope this helps!
0 Luke Ridgway over 3 years ago in reply to Alex Nassi

Brilliant @Alex Nassi... Thank you for both bits of info
0 Enes Saridogan over 3 years ago
Hi Luke Ridgway,

I have almost the same problem, I want to display the assigned username, but nothing happens. I can see that you managed to display it, how did you arrive ?

Here is my code for the assigned username :

Fullscreen
1
2
3
4
5
6
7
8
array (
'name' => 'assigned_user_name',
'label' => 'LBL_LIST_ASSIGNED_USER',
'enabled' => true,
'default' => true,
'id' => 'ASSIGNED_USER_ID',
'link' => true,
),
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
array ( 'name' => 'assigned_user_name', 'label' => 'LBL_LIST_ASSIGNED_USER', 'enabled' => true, 'default' => true, 'id' => 'ASSIGNED_USER_ID', 'link' => true, ),

Do I have to change something else ?

Thanks in advance for your help.

Best regards,

Enes
0 Luke Ridgway over 3 years ago in reply to Enes Saridogan

Hi Enes Saridogan,

Sorry, I haven't opened the CLub for ages...

Also sorry as I have no idea how we are displaying the Assigned to username in my screenshot of the dupe check above.

I have looked at each view option in Studio and in Module Builder (that screenshot is a custom module, Case Attachments) but no layout has the assigned to username available, at all.

So I am not sure. I have not been able to look further into my own question for this yet either.

Ever so sorry, not very helpful :-(
Luke.
0 Enes Saridogan over 3 years ago in reply to Luke Ridgway

Hi Luke,

No problem. :-)

Can you maybe share me the code of your dupe-check view ? I think it would have no more thing that I shared before ...

Thanks in advance and have a nice week.

Enes
0 Enes Saridogan over 3 years ago in reply to Luke Ridgway

Hello again Luke,

Some additional precisions, I have the same piece of code for the native dupecheck-list.php file in Contacts module, in Contacts it displays the Assigned user, in Accounts it wouldn't ...
+1 Enes Saridogan over 3 years ago in reply to Enes Saridogan

Hi Luke Ridgway,

I finally find by myself the solution.

In fact, I created a custom DuplicateCheck for the Accounts module, and when you do that, you can't get the linked modules fields ... because it is not "standard" field.

I only added a join to the table users and build by myself the assigned user name.

And it works like a charm :-)

Hope this trick will save other lives :-D

Best regards,

Enes