top_en
Main page

Bitrix24Care

Bitrix24.CRM - Update 17.5.4

Rating:
In the Bitrix24.CRM Version 17.5.4 we have added the possibility to search for duplicates not only by fields of Contacts and Companies, but also by their details.

When installing this update, it is necessary to rebuild indexes in tables. This operation can take a lot of time, especially if you have a lot of Contacts and Companies. In this case, it would be faster and safer to proactively execute queries by yourself via MySQL console.

Queries that are required to be executed:

ALTER TABLE b_crm_dp_entity_hash DROP PRIMARY KEY;
ALTER TABLE b_crm_dp_entity_hash DROP INDEX IX_B_CRM_DP_ENT_HASH_1;
ALTER TABLE b_crm_dp_entity_hash MODIFY TYPE_ID INT UNSIGNED NOT NULL;
ALTER TABLE b_crm_dp_entity_hash ADD SCOPE VARCHAR(6) NOT NULL DEFAULT '';
ALTER TABLE b_crm_dp_entity_hash ADD PRIMARY KEY (ENTITY_ID, ENTITY_TYPE_ID, TYPE_ID, MATCH_HASH, SCOPE);
ALTER TABLE b_crm_dp_entity_hash ADD INDEX IX_B_CRM_DP_ENT_HASH_1 (ENTITY_TYPE_ID, TYPE_ID, MATCH_HASH, SCOPE, ENTITY_ID, IS_PRIMARY);
ALTER TABLE b_crm_dp_index DROP PRIMARY KEY;
ALTER TABLE b_crm_dp_index DROP INDEX IX_B_CRM_DP_IND_1;
ALTER TABLE b_crm_dp_index DROP INDEX IX_B_CRM_DP_IND_2;
ALTER TABLE b_crm_dp_index DROP INDEX IX_B_CRM_DP_IND_3;
ALTER TABLE b_crm_dp_index DROP INDEX IX_B_CRM_DP_IND_4;
ALTER TABLE b_crm_dp_index DROP INDEX IX_B_CRM_DP_IND_5;
ALTER TABLE b_crm_dp_index DROP INDEX IX_B_CRM_DP_IND_6;
ALTER TABLE b_crm_dp_index MODIFY TYPE_ID INT UNSIGNED NOT NULL;
ALTER TABLE b_crm_dp_index ADD SCOPE VARCHAR(6) NOT NULL DEFAULT '';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_INN_FLAG CHAR(1) NOT NULL DEFAULT '1';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_INN VARCHAR(15) NOT NULL DEFAULT '';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_OGRN_FLAG CHAR(1) NOT NULL DEFAULT '1';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_OGRN VARCHAR(13) NOT NULL DEFAULT '';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_OGRNIP_FLAG CHAR(1) NOT NULL DEFAULT '1';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_OGRNIP VARCHAR(15) NOT NULL DEFAULT '';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_BIN_FLAG CHAR(1) NOT NULL DEFAULT '1';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_BIN VARCHAR(12) NOT NULL DEFAULT '';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_EDRPOU_FLAG CHAR(1) NOT NULL DEFAULT '1';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_EDRPOU VARCHAR(10) NOT NULL DEFAULT '';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_VAT_ID_FLAG CHAR(1) NOT NULL DEFAULT '1';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_VAT_ID VARCHAR(20) NOT NULL DEFAULT '';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_ACC_NUM_FLAG CHAR(1) NOT NULL DEFAULT '1';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_ACC_NUM VARCHAR(34) NOT NULL DEFAULT '';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_IBAN_FLAG CHAR(1) NOT NULL DEFAULT '1';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_IBAN VARCHAR(34) NOT NULL DEFAULT '';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_IIK_FLAG CHAR(1) NOT NULL DEFAULT '1';
ALTER TABLE b_crm_dp_index ADD ROOT_ENTITY_RQ_IIK VARCHAR(20) NOT NULL DEFAULT '';
ALTER TABLE b_crm_dp_index ADD PRIMARY KEY (USER_ID, ENTITY_TYPE_ID, TYPE_ID, MATCH_HASH, SCOPE);
ALTER TABLE b_crm_dp_index ADD INDEX IX_B_CRM_DP_IND_1 (USER_ID, ENTITY_TYPE_ID, ROOT_ENTITY_NAME_FLAG, ROOT_ENTITY_NAME(255), TYPE_ID, SCOPE);
ALTER TABLE b_crm_dp_index ADD INDEX IX_B_CRM_DP_IND_2 (USER_ID, ENTITY_TYPE_ID, ROOT_ENTITY_TITLE_FLAG, ROOT_ENTITY_TITLE(255), TYPE_ID, SCOPE);
ALTER TABLE b_crm_dp_index ADD INDEX IX_B_CRM_DP_IND_3 (USER_ID, ENTITY_TYPE_ID, ROOT_ENTITY_PHONE_FLAG, ROOT_ENTITY_PHONE(255), TYPE_ID, SCOPE);
ALTER TABLE b_crm_dp_index ADD INDEX IX_B_CRM_DP_IND_4 (USER_ID, ENTITY_TYPE_ID, ROOT_ENTITY_EMAIL_FLAG, ROOT_ENTITY_EMAIL(255), TYPE_ID, SCOPE);
ALTER TABLE b_crm_dp_index ADD INDEX IX_B_CRM_DP_IND_5 (MATCH_HASH, TYPE_ID, ENTITY_TYPE_ID, SCOPE);
ALTER TABLE b_crm_dp_index ADD INDEX IX_B_CRM_DP_IND_6 (ROOT_ENTITY_ID, ENTITY_TYPE_ID, SCOPE);
ALTER TABLE b_crm_dp_index ADD INDEX IX_B_CRM_DP_IND_7 (USER_ID, ENTITY_TYPE_ID, ROOT_ENTITY_RQ_INN_FLAG, ROOT_ENTITY_RQ_INN(15), TYPE_ID, SCOPE);
ALTER TABLE b_crm_dp_index ADD INDEX IX_B_CRM_DP_IND_8 (USER_ID, ENTITY_TYPE_ID, ROOT_ENTITY_RQ_OGRN_FLAG, ROOT_ENTITY_RQ_OGRN(13), TYPE_ID, SCOPE);
ALTER TABLE b_crm_dp_index ADD INDEX IX_B_CRM_DP_IND_9 (USER_ID, ENTITY_TYPE_ID, ROOT_ENTITY_RQ_OGRNIP_FLAG, ROOT_ENTITY_RQ_OGRNIP(15), TYPE_ID, SCOPE);
ALTER TABLE b_crm_dp_index ADD INDEX IX_B_CRM_DP_IND_10 (USER_ID, ENTITY_TYPE_ID, ROOT_ENTITY_RQ_BIN_FLAG, ROOT_ENTITY_RQ_BIN(12), TYPE_ID, SCOPE);
ALTER TABLE b_crm_dp_index ADD INDEX IX_B_CRM_DP_IND_11 (USER_ID, ENTITY_TYPE_ID, ROOT_ENTITY_RQ_EDRPOU_FLAG, ROOT_ENTITY_RQ_EDRPOU(10), TYPE_ID, SCOPE);
ALTER TABLE b_crm_dp_index ADD INDEX IX_B_CRM_DP_IND_12 (USER_ID, ENTITY_TYPE_ID, ROOT_ENTITY_RQ_VAT_ID_FLAG, ROOT_ENTITY_RQ_VAT_ID(20), TYPE_ID, SCOPE);
ALTER TABLE b_crm_dp_index ADD INDEX IX_B_CRM_DP_IND_13 (USER_ID, ENTITY_TYPE_ID, ROOT_ENTITY_RQ_ACC_NUM_FLAG, ROOT_ENTITY_RQ_ACC_NUM(34), TYPE_ID, SCOPE);
ALTER TABLE b_crm_dp_index ADD INDEX IX_B_CRM_DP_IND_14 (USER_ID, ENTITY_TYPE_ID, ROOT_ENTITY_RQ_IBAN_FLAG, ROOT_ENTITY_RQ_IBAN(34), TYPE_ID, SCOPE);
ALTER TABLE b_crm_dp_index ADD INDEX IX_B_CRM_DP_IND_15 (USER_ID, ENTITY_TYPE_ID, ROOT_ENTITY_RQ_IIK_FLAG, ROOT_ENTITY_RQ_IIK(20), TYPE_ID, SCOPE);
ALTER TABLE b_crm_dp_index_mismatch DROP PRIMARY KEY;
ALTER TABLE b_crm_dp_index_mismatch MODIFY TYPE_ID INT UNSIGNED NOT NULL;
ALTER TABLE b_crm_dp_index_mismatch ADD SCOPE VARCHAR(6) NOT NULL DEFAULT '';
ALTER TABLE b_crm_dp_index_mismatch ADD PRIMARY KEY (USER_ID, ENTITY_TYPE_ID, TYPE_ID, MATCH_HASH, L_ENTITY_ID, R_ENTITY_ID, SCOPE);


This helped Thanks :) This didn't help Sorry :(
Could you please tell us why:
It's not what I'm looking for
It's too complicated

Did not find an answer to your question?

Send your question to the Bitrix24Care team
Access to technical support specialists requires commercial plan subscription and is not available to free account users. Free accounts are limited to self-support resources such as product manuals, helpdesk articles, video tutorials, and free webinars. Technical assistance, training, setup, customization and other value added services can also be purchased directly from local Bitrix24 partners