Tweet
How can I make a field that can not be duplicated?
-
-
Hello
add 'duplicateIgnore' to field defs.
in custom/Espo/Custom/Resources/metadata/entityDefs/<EntityName>.json
{
"fields":{
"<fieldName>":{
"duplicateIgnore":true
}
}
} -
In case I want the same field not to be duplicated both in the leads and in the accounts, how do I do it? es. phone numberComment
-
What do you mean?
Duplicate action or convert lead action?
For duplicate action - "duplicateIgnore":true for all field and for all scopes you needComment
-
I'll explain better, I have already entered a lead with all the data including the phone number and also an example ID VAT, then another user, however, directly enters an account with the same ID VAT, how can I avoid this?Comment
-
Comment
-
I changed custom/Espo/Custom/Resources/metadata/entityDefs/Lead.json
added
"name":{
"duplicateIgnore":true
}
but no luck...Comment
-
This parameter is used, when you click Duplicate button on the detail view. Fields with this parameter will be emptyComment
-
oh... I see
I think I need to add getDuplicateWhereClause function
but where?
application/Espo/Modules/Crm/Services/Lead.php?Comment
-
In custom Lead service
https://forum.espocrm.com/forum/deve...d-into-account (here you can find the path)Comment
-
Here is my code:
<?php
namespace Espo\Custom\Services;
class Lead extends \Espo\Modules\Crm\Services\Lead
{
protected function getDuplicateWhereClause(Entity $entity, $data = array())
{
return array(
'OR' => array(
array(
'phoneNumber' => '%' . $entity->get('phoneNumber') . '%'
),
array(
'emailAddress' => $entity->get('emailAddress'),
),
),
);
}
}
?>
on update I've got error: Bad ResponseLast edited by pavel_s; 05-22-2018, 02:24 PM.Comment
-
Thats working code:
<?php
namespace Espo\Custom\Services;
use \Espo\ORM\Entity as Entity;
class Lead extends \Espo\Modules\Crm\Services\Lead
{
protected function getDuplicateWhereClause(Entity $entity, $data = array())
{
$data = array(
'OR' => array()
);
if ($entity->get('emailAddress')) {
$data['OR'][] = array(
'emailAddress' => $entity->get('emailAddress'),
);
}
if ($entity->get('phoneNumber')) {
$data['OR'][] = array(
'phoneNumber' => '%' . $entity->get('phoneNumber') . '%'
);
}
return $data;
}
}
?>
Comment
-
I'm sorry... but I still got problem with duplicate
I don't know why tomorrow it worked perfectly, but today I got the same error - 409 duplicateComment
Comment