Check duplication based on field condition in sugarcrm 7

Question

Am checking duplicate check in Accounts module based on some filed condition.

In Account i have a dropdown field called Account Type with options as
1. Organisation

2. Individual

if i select Account Type == Organisation then i have to check duplicates for some specific fields field1,field2,field3,field4.

and

if i select Account Type == Individual then i have to check duplicates for fields field1,field2,field5,field6.

How this can be achieve in sugarcrm 7.7 version.

I found one article for Duplication check but i want conditional based duplication checkup

Can any one please help me out from this

Thanks in advance

Regards

Sam

Sam Roy · Accepted Answer

Hi Sam Roy You can try following code, which worked for me: ./custom/Extension/modules/Accounts/Ext/Vardefs/.php $dictionary['Account']['duplicate_check']['FilterDuplicateCheck'] = array( 'filter_template' => array( array( '$or' => array( array( '$and' => array( array('account_type' => array('$equals' => 'Organisation')), array( '$or' => array( array('field1' => array('$equals' => '$field1')), array('field2' => array('$equals' => '$field2')), array('field3' => array('$equals' => '$field3')), array('field4' => array('$equals' => '$field4')) ) ), ) ), array( '$and' => array( array('account_type' => array('$equals' => 'Individual')), array( '$or' => array( array('field1' => array('$equals' => '$field1')), array('field2' => array('$equals' => '$field2')), array('field5' => array('$equals' => '$field5')), array('field6' => array('$equals' => '$field6')) ) ), ) ), ) ), ), ); Or if you want to check for more condition base then go for below code: ./custom/Extension/modules/Accounts/Ext/Vardefs/.php true, 'OneFieldDuplicateCheck' => array( 'field' => 'name' ) ); Replace OneFieldDuplicateCheck with following: 'MultipleFieldDuplicateCheck' => array( 'field' => 'account_type', 'field1' => 'xxxxx', 'field2' => 'xxxxx', 'field3' => 'xxxxx', 'field4' => 'xxxxx', 'field5' => 'xxxxx' ) Now ./custom/data/duplicatecheck/MultipleFieldDuplicateCheck.php field1 = $metadata['field1']; $this->field2 = $metadata['field2']; $this->field3 = $metadata['field3']; $this->field4 = $metadata['field4']; $this->field5 = $metadata['field5']; } } public function findDuplicates() { if($this->bean->{$this->field} == 'Individual'){ $Query = new SugarQuery(); $Query->from($this->bean); $Query->where()->queryOr()->ends($this->field1,$this->bean->{$this->field1})->equals($this->field2,$this->bean->{$this->field2})->equals($this->field5,$this->bean->{$this->field5})->equals($this->field6,$this->bean->{$this->field6}); //Filter out the same Bean during Edits if (!empty($this->bean->id)) { $Query->where()->notEquals('id',$this->bean->id); } $Query->limit(10); }else if($this->bean->{$this->field} == 'Organisation'){ $Query = new SugarQuery(); $Query->from($this->bean); $Query->where()->queryOr()->ends($this->field1,$this->bean->{$this->field1})->equals($this->field2,$this->bean->{$this->field2})->equals($this->field3,$this->bean->{$this->field3})->equals($this->field4,$this->bean->{$this->field4}); //Filter out the same Bean during Edits if (!empty($this->bean->id)) { $Query->where()->notEquals('id',$this->bean->id); } $Query->limit(10); } $results = $Query->execute(); return array( 'records' => $results ); } } Hope this Helps Best Regards S Ramana Raju