I have added a Custom Field called Division to Accounts in a table called accounts_cstm
When saving a new account I want to keep the Standard âShowDuplicatesâ functionality but when the âDuplicate listâ is shown I would like an extra column containing the Division information.
This is controlled by ShowDuplicates.php and ShowDuplicates.html in Modules/Accounts.
I changed the sql Query to correctly get Data from both tables BUT I am not sure how to amend the Javascript below to show the extra column. Suggestions appreciated
$query = âselect accounts.id, accounts_cstm.department_c, accounts.name, accounts.website, accounts.billing_address_city from accounts inner join accounts_cstm on accounts.id=accounts_cstm.id_c where accounts.deleted=0â;
/** Original Query $query = 'select id, name, website, billing_address_city from accounts where deleted=0 ';88?